blueline Posted March 14, 2004 Share Posted March 14, 2004 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 More sharing options...
tictric Posted March 14, 2004 Share Posted March 14, 2004 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 More sharing options...
Mark Evans Posted March 14, 2004 Share Posted March 14, 2004 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 More sharing options...
Mark Evans Posted March 14, 2004 Share Posted March 14, 2004 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 More sharing options...
blueline Posted March 14, 2004 Author Share Posted March 14, 2004 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 More sharing options...
Mark Evans Posted March 14, 2004 Share Posted March 14, 2004 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 More sharing options...
blueline Posted March 14, 2004 Author Share Posted March 14, 2004 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 More sharing options...
project_aism Posted March 15, 2004 Share Posted March 15, 2004 How about some benchmarks to show case the new OSC cache? The easier solution is to install mysql 4.0 with query cache and with plenty of memory > 512mb. You don't have to wait for ms3 either. Link to comment Share on other sites More sharing options...
blueline Posted March 16, 2004 Author Share Posted March 16, 2004 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 More sharing options...
rpertiet Posted March 17, 2004 Share Posted March 17, 2004 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 More sharing options...
blueline Posted March 17, 2004 Author Share Posted March 17, 2004 Thanks. I'll take a look at these. -Chris Chris Sullivan Link to comment Share on other sites More sharing options...
blueline Posted March 17, 2004 Author Share Posted March 17, 2004 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.