Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Make osC a lot faster.


blueline

Recommended Posts

Was looking through the database structure, and I really don't see many indexes. Was wondering why more aren't used, and if the use of DB indexing will be implemented more in MS3.

 

Thanks,

-Chris

Chris Sullivan

Link to comment
Share on other sites

As I don't know really very much about databases I'm just courious how an index would affect a shopscript?

I mean data access is pretty straight forward.

You don't need to search, really.

 

regards

Link to comment
Share on other sites

This is something we are addressing at the moment.

 

Along with indexes you will see the introduction of a new database class which has caching on a per query functionality which will improve performance for large stores and stores with a lot of traffic.

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

As I don't know really very much about databases I'm just courious how an index would affect a shopscript?

This article explains how indexes increase performance quite nicely :)

 

http://www.myitforum.com/articles/18/view.asp?id=5570

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

Thanks sparky. I'm surrently developing a site for a client that will use osC....with a lot of customization.

 

We will be listing roughly 100,000 products, with 2.7 million different pricing options....and I'm wondering how osC is gonna hold up for this type of shop.

 

Any ideas?

 

Thanks,

-Chris

Chris Sullivan

Link to comment
Share on other sites

We will be listing roughly 100,000 products, with 2.7 million different pricing options....and I'm wondering how osC is gonna hold up for this type of shop.

I dont ;)

 

I take it that you will base the store on MS-2?

 

If you take a look in current CVS you will see the start of the new DB class has been introduced.

 

It would be a very interesting excercise to see the performance difference on such a large store.

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

Ok. Yes, we will be using MS2.

 

I was hoping that introducing new indexes into the DB will help, as I am afraid to see what type of performance setbacks we are going to have.

Chris Sullivan

Link to comment
Share on other sites

Thought I would privde an update. I made a mistake....there won't be 2.7 million different pricing entries in the DB.....THERE'S GONNA BE 90 MILLION.

 

....As scary as that is.

 

-Chris

Chris Sullivan

Link to comment
Share on other sites

I read this on a forums earlier and have used this on my site. I'm no where near the size you suggest, but these will help.

 

alter table categories add index (sort_order);

 

alter table customers add index (customers_email_address);

 

alter table orders add index (customers_id);

 

alter table products add index (products_model), add index (products_price), add index (products_date_available), add index (manufacturers_id);

 

alter table products_attributes add index (products_id), add index (options_id);

 

alter table products_options add index (products_options_name);

Link to comment
Share on other sites

alter table products add index (products_model), add index (products_price), add index (products_date_available), add index (manufacturers_id);

So if I use this command, will it index the model, price, date_available, and manufacturers id all together or serperately?

 

I main index I'm worried about (in the table with 90 Million + entries) is gonna be customer_id, product_id, product_type_id, product_price .... and I'd like to index the customer_id, product_id, and product_type_id all together.

 

Thanks,

-Chris

Chris Sullivan

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...