Hello,
I'm unable to use simple or advanced_search. I have more than 100K books. It takes forever (and 100% CPU.) Server here is a new Xeon with 8 Gb Ram and SSD disk
Commenting the lines $extra_from and $extra_where in the function insert_book_attributes_into_search_query fix the issue (obviously) returning the search queries in no more than 1.4-1.6 seconds (0.5 when cached)
Sorry I'm not a mysql guy. Any clue please?
Cheers
Results 1 to 10 of 427
Threaded View
-
9 Mar 2019, 12:24 AM #32
New Zenner
- Join Date
- Oct 2010
- Location
- Andalucía
- Posts
- 15
- Plugin Contributions
- 0
Re: New add-on "product type book" for ZC 1.5
Reply With QuoteSimilar Threads
-
Why "No, Normal Shipping Rules" option for a "Product - Free Shipping" type?
By ilikemike in forum Built-in Shipping and Payment ModulesReplies: 3Last Post: 31 Dec 2011, 12:34 AM -
How do I add "www." to "http://mydomain.com/..." for each link on my website pages?
By bnamodel in forum General QuestionsReplies: 5Last Post: 11 Sep 2009, 04:51 AM -
Different "Sold Out" images for each product type
By Starlyn in forum Setting Up Categories, Products, AttributesReplies: 13Last Post: 20 Mar 2009, 10:37 PM -
Remove "Add: [ ]" and "Add selected products to cart" from product pages? possible?
By edwardtilbury in forum Templates, Stylesheets, Page LayoutReplies: 3Last Post: 1 Sep 2008, 03:13 AM -
"Array()" line on "Update Address Book" page
By vera in forum Managing Customers and OrdersReplies: 10Last Post: 22 Sep 2006, 03:06 AM
Bookmarks