The site I'm working on today is a book shop for magicians. Fun stuff, huh? The inventory is slightly over 10,000.
The Feature Page showcases 4 items (listed below).
The "SELECT [col_names] FROM inventory" repeats in each query, basics like title, author, price; however, the "WHERE attributes" are so diverse that a subquery won't work.
Does the data cache, or will the user have to wait while the "inventory table" gets scanned 4 separate times for that one page?
Dfly
====================
Instead of writing out the all the queries, I listed the results wanted, followed by the table & the main conditional column.
#1 - certain topic in the title, item not new or on sale
inventory tbl - title col
#2 - title with large stock#, item not new or on sale
inventory tbl - stock col
#3 - lists 3 sale titles
inventory tbl / sale table join by item_id
#4 - lists 3 new arrivals
inventory tbl - date_rcvd col
The Feature Page showcases 4 items (listed below).
The "SELECT [col_names] FROM inventory" repeats in each query, basics like title, author, price; however, the "WHERE attributes" are so diverse that a subquery won't work.
Does the data cache, or will the user have to wait while the "inventory table" gets scanned 4 separate times for that one page?
Dfly
====================
Instead of writing out the all the queries, I listed the results wanted, followed by the table & the main conditional column.
#1 - certain topic in the title, item not new or on sale
inventory tbl - title col
#2 - title with large stock#, item not new or on sale
inventory tbl - stock col
#3 - lists 3 sale titles
inventory tbl / sale table join by item_id
#4 - lists 3 new arrivals
inventory tbl - date_rcvd col