It's the old story
Normalize your tables
Use indexes on commonly called fields
Fetch items only as needed, within reason.
Remember that the web is stateless, so when you zero in for more data you
will be refreshing the page from the server.
One thousand items is very few for a database, try
I think your best bet is to only show product titles, and possibly a bit
of the summary or something in the catalogue, then have the user click
the product to view full information on it.
this takes 2 db calls, one to load the limited info of all products, and
one to load all info on one product.
2 matches
Mail list logo
