I have a products database with 3000 items.
And on one master product list, I would list them all. I did a multiple tables query, 5 tables in total, they are table: product, table: subcategory, table: category and 2 tables for the "many to many" relations of product&subcategory, and subcategory&category.
And it took so long to finish.
The database is InterBase. And when I have several hundreds products, it is fine. But when I have 3000 items, it takes much longer than when I have several hundreds prdoucts.
How can I improve the performance for the database in my query design?
Is it suppose to take very long to search for a 3000 products database and list at one page?
Also to keep the codes clean. (try not to mess up the php codes and html codes too much) I used several arrays to pre-hold different fields of the products. This php part I put it before any html tags.
And then later on in the display part (with the html format tags), I only "walk through" these arrays to display the information.
I think this also hurt the performance.
Any suggestions to improve the performance? How to do a good php database programming in terms of performance? links to the good articles of this issue, please.
Is it a database performance problem, or it is just taking that time to display a very long html page?
I know it is not a good design for 3000 products, so I am going to reprogram this part. But I still want to know the database performance related answers.
Thanks!
