Server performance is generally dragged down by numerous hits (queries) on the database. I can avoid some of these queries by performing searches across multiple tables. But this creates a cartesian product which, according to my reading, drags down the performance of the server. So is there a way around this? If there is no way around this, which is better? Writing a script that runs two or three queries on the same database? Or writing a script that performs one query but then creates a cartesian product?
hits vs. cartesian products
- Thread starter wxdqz
- Start date