i found this link on google, hanks nice tuts

All my tables have primary keys, so that’s not the problem. :mrgreen: I just want to optimize the queries that do not rely on them.

All tables in a database should really have either a Primary Key or an Index on one of the columns – it’s good practise and, as you found out, *really* speeds it up!

You could put a disclaimer on the page saying IE is bad and should not be used :P

I took out that long URL from you post and made it into a link – sorry. It was breaking the layout. I need to conjure up get a line-breaking script like the slashdot lameness filter for the comments section one of these days.

Thanks for the SpreadsheetML link. I will definitely look into it. I was actually using a PHP class (sourceforge is your friend) to generate the files, but this may be a good alternative.

The AJAX thing is a good idea – thanks. But then again, I know they like to print out the big tables so I still want to give them the ability to have all the information loaded on the page at once.

Regarding that Excel report you are working on, you could try SpreadSheetML. I’ve been working with it lately and it’s pretty cool :-)!!!!

All you have to do is to build an XML using that schema/namespace, set the contentype right and you’re ok to go.

You can find some info on SpreadsheetML here.

Jorge

Try AJAX! You can create a page that returns only some results (say 20 each page), and build a navigation bar with AJAX without having to post back the request to the server. Users seem to like this kind of feature and since the page won’t reload, everything seems faster.

All you have to do is build an URL that returns XML with a set of the results and parse it in Javascript.

Jorge