osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Hot to? Joining/combining tables

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 ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Modification Help

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 05-07-2003, 06:21 AM
Lurker
 
Join Date: Mar 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
mamuka
Default Hot to? Joining/combining tables

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 06:13 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax