Dear Sir/Madam,
i have an ASP application in such way the the first page the user should enter his name and password and then this will transfer him to another page , in this second page once the user enters a Mobile no it will make connection to the database ( oracle 8i) and will display information and details about the entered mobile no and the user can update this record ,
the problem is sometimes when the user enters the mobile no , it will be very slow to retreive its details from the database
so please let me know what is the problem , is it from my Asp application if so please let me know how i can speed up this application
or is it from the database so if the problem from the database please let me know how i can solve this problem
( by the way so many users are using this application at a time and i have around 145000 record in my table)
