This is a discussion on Hot to? Joining/combining tables within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; Hi everybody! I have a problem with loading-time. I was sugested to reduse number of tables accessed simultaneously. In my ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| Hi everybody! I have a problem with loading-time. I was sugested to reduse number of tables accessed simultaneously. In my case (I have more than 3000 products and aprox. 300 categories) I just want to join/combine folowing tables: categories+categories_description = categories [exluding same rows] and poducts+products_description = products Partially I have allready join categories and categ._descr. modifying following files: admin/include/application_top.php catalog/include/application_top.php -------------------------------------------- I have change(replase) define(table_categories_description) with (categories) catalog/../general.php cat./../header_tags.php cat./index.php (default.php) cat/../boxes/categories.php ----------------------------------------- I have replase ". table_categories ." c, ". table_categories_description." Now, the question. Please tell me if it is enough or I need to do some additional changes, and where exactly. If you have questions or I made myself not understandable - contact me at mamuka@gmx.net Regards |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| "search_queries" tables | jonsc | osCMax v2 Features Discussion | 2 | 11-07-2005 03:41 AM |
| Joining the Dynamic MoPics club of issues. | tdiaz | osCMax v1.7 Discussion | 3 | 03-25-2005 04:35 PM |
| How to create shipping tables with ounces AND pounds? | SANDRINE | osCommerce 2.2 Modification Help | 0 | 10-03-2004 10:56 AM |
| Tables not installing | Arpit | osCommerce 2.2 Installation Help | 1 | 08-26-2003 09:51 AM |