Optimize load of asp-page with MySQL data...
Hello out there. :-)
I have a webdatabase (Classic asp and MySQL) located on a webhotel. An overview page loads an overview of the main records in the database (relational database). Right now there's about 1.800 records in the table that the Query pulls. It shows 20 records a time and has got a page navigation panel to go from record 1 to 20, 21 to 40 and so on. First time the user opens it, it takes almost 10 seconds. After that you can navigate back and forth quick enough.
Can I optimize the SQL Query so it will load faster? I thought about something like "SELECT TOP 20" to load the first 20 records, but won't that affect the page navigation and the info about the total number of records in the database?
I appreciate some hints big time. :-)
Best regards
Ulrich
I have a webdatabase (Classic asp and MySQL) located on a webhotel. An overview page loads an overview of the main records in the database (relational database). Right now there's about 1.800 records in the table that the Query pulls. It shows 20 records a time and has got a page navigation panel to go from record 1 to 20, 21 to 40 and so on. First time the user opens it, it takes almost 10 seconds. After that you can navigate back and forth quick enough.
Can I optimize the SQL Query so it will load faster? I thought about something like "SELECT TOP 20" to load the first 20 records, but won't that affect the page navigation and the info about the total number of records in the database?
I appreciate some hints big time. :-)
Best regards
Ulrich
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Big Monty.
Oh... my browser must have been acting up. How can I change that?
Best regards
Ulrich
Oh... my browser must have been acting up. How can I change that?
Best regards
Ulrich
you can hit the Request Attention link and someone will come along and open it back up for you
both answers gave you what you were looking for