Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2008
    Location
    Surbiton, UK
    Posts
    5
    Plugin Contributions
    0

    Default 26 seconds to display one item!!!

    Ok, tell me I'm trying to squeeze a quart into a pint pot...

    I have 310,000 products loaded. They are all in one category. This is the entire Yamaha outboard spare parts list. I'm about to add another 200k+ items from other manufacturers, but won't until I've solved this one. This will be a very simple site. Type your part number into the search, then place it in your basket.

    However, it takes 26 seconds to retrieve a part's details, so it's kinda doomed before it starts! If I click on the Yamaha manufacturer link, it times out on the browser.

    It's hidden, but if anyone wants to try the dev site, it's now publicly viewable for a while at http://yamSpares.kingsmarine.co.uk/yamSpares.

    Try a search for 6E0443520000

    I've tried looking through the advanced_search.php file, as I can get away with limiting the search to just the model field. However, I think there's more to it than that!

    Any help much appreciated.

  2. #2
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,739
    Plugin Contributions
    0

    Default Re: 26 seconds to display one item!!!

    As far as I can tell you are on an extremely slow server. It took the 26 second to search but once I was there and click on the product to go to the product info page it took Parse Time: 22.269 - Number of Queries: 177 - Query Time: 13.340543674347 to display the product info page..........Sounds like a crappy server to me.
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  3. #3
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: 26 seconds to display one item!!!

    Are you or is this a server that you have setup?
    Zen-Venom Get Bitten

  4. #4
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,571
    Plugin Contributions
    1

    Default Re: 26 seconds to display one item!!!

    I have 310,000 products loaded. They are all in one category.
    That's your problem. I don't care what Server the account is on, it's going to take "X" amount of time to search and the more Products in one Catagory the longer it takes.

    Is there some reason you are not setting up Sub-catagories?
    That would greatly decrease the Search / Load time.

  5. #5
    Join Date
    Jul 2008
    Location
    Surbiton, UK
    Posts
    5
    Plugin Contributions
    0

    Default Re: 26 seconds to display one item!!!

    Categories.... ok...
    the product data comes to me as; 'partNum, partDescription, price' That's about it! So I have no logical method of dividing it into categories. I will have other categories for other manufacturers. I've been trying to look at the parse times in the log files (in /cache folder) to see where the main bottleneck is, but currently it has secured them against me downloading them and I can't chmod them either!

    Onwards and upwards....
    www.KingsMarine.co.uk - actinic, but going away.
    yamspares.kingsmarine.co.uk/yamSpares - new Zencart dev site. :)

  6. #6
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: 26 seconds to display one item!!!

    I have 310,000 products loaded. They are all in one category.
    You might try creating logical catrgories for these items to use the indexing facilities.....

    Like for the product #you posted this could be a sub-cat for "Impellers" or "Props"??
    Zen-Venom Get Bitten

  7. #7
    Join Date
    Jul 2008
    Location
    Surbiton, UK
    Posts
    5
    Plugin Contributions
    0

    Default Re: 26 seconds to display one item!!!

    Yah! Managed to get the product search and display down to under half a second, from 34 seconds for some. Essentially, as this is part numbers, I changed the modules/pages/advanced_search_result/header_php.php file and deleted the search of meta tags and description, and instead of a full ('%:keyword%') search, it now does a starts-with search (':keyword%') on the model field.

    Not ideal, but in the situation where there is only a part number to be searched and it is only in one field, it does what I need, and quickly too.

    I should add many many thanks to those who responded to me by PM offering time and processor cycles to help solve this one. Really glad I decided to try and become a zenner!! I still haven't got the hoster to change mysql so that I can get my data out yet. Keeps timing out. Time to move onto the next problem... getting some customer!
    www.KingsMarine.co.uk - actinic, but going away.
    yamspares.kingsmarine.co.uk/yamSpares - new Zencart dev site. :)

 

 

Similar Threads

  1. First page load is 6 seconds, subsequent is 0.01 seconds. VPS, loads of RAM.
    By kelvyn in forum Installing on a Linux/Unix Server
    Replies: 11
    Last Post: 21 Mar 2011, 05:48 AM
  2. Free shipping on one item in USA and with purchase of another item
    By jendera in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 30 Dec 2009, 01:00 AM
  3. Replies: 0
    Last Post: 17 Mar 2009, 03:22 AM
  4. allow to buy one item, only if an other item is selected
    By liliebrode in forum Managing Customers and Orders
    Replies: 0
    Last Post: 2 Jun 2008, 12:59 PM
  5. Purchasing one item requires second item purchase
    By furnitur in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 7 Jan 2007, 04:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR