Simple question on query speed - I hope

[netfrugal]

After optimizing my database tables my queries are running smoother and a little bit faster.

I have thousands of rows of data to view and everyday I need to wait for a while for the results to show up on the browser.

My question is: Does paginating speed up the query? Or is there another way to speed up the query?

Currently all results are showing in a repeating table, so I have alot of scrolling to do. But I'm open to other ideas for possible faster results.

thanks!

[NogDog]

I would think pagination would give you faster initial response, though of course the time to view the entire dataset would take longer. The actual query response time probably wouldn't be much different, but then there would be less data to transmit between MySQL and PHP, less data for PHP to process in fewer loops, and then less data to transmit across the network to the browser.

As with any performance questions, if you can do some metering and determine where the specific bottlenecks are, then you don't have to speculate and optimize by trial and error, but can instead concentrate on those specific bottleneck points.

Also, when you say you've optimized your database tables, did that include creating indexes for columns which are used in your "where" clauses?

[netfrugal]

You are right, the query response time is about the same.

I optimized the data from the phpmyadmin interface. The WHERE clause I use is a regular expression in one of the columns:

WHERE xyz LIKE '%Banned Regular Expression URL%'

It's an internet log file, which is immense.