my website: [url removed, login to view]
we have a price calculator that takes values from two different tables in the database. the query is doing a select and because the tables are now 100,000 rows long - it is taking a long time to bring back the price on the website. therefore i now would like to merge the two tables that run this query.
tbl_product - contains all the product data and information for the calculator except for the price and quantity
tbl_product_detail - contains price and quantity.
1. to merge these two tables together to make sure all products and prices go with the correct data in the adjacent table.
2. to change any php code that may need to be changed due to the changes in merging the table.
This is critical and needs to be done today.
If you can do it today without hassle and know what you are doing. let me know!