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. :-)