I am trying to put limits on my SQL satatements in my ASP pages to speed up the page however when I use a statement:
select * from Table Limit 1
or
select * from Table Limit 0, 1
in my sql statements it comes up Incorrect Santax?
I have a query that returns a resultset rather fast, but when I go through the loop to write it out to the page I get a slow display. Is there a way to speed this up?
View Replies View RelatedI've got this code that loops through a recordset and prints the whole thing out in an html table. Sometimes it takes 30 seconds to a minute to display a little over 2000 records (like 25 columns). My boss feels that it needs to be faster even though another internal reporting system that works similarly takes far longer than mine.
I've ruled out the database execution. I have code that prints out after it finishes going to the database. It shows up almost immediately.
I set up a javascript timer that says the entire execution, including the database, is taking around 1.5 seconds every time.e.