Inhalte aufrufen

Profilbild

Search speed on instance's search


  • Bitte melden Sie sich an, um eine Antwort zu verfassen.
3 Antworten zu diesem Thema

#1 mahdavi

mahdavi

    Newbie

  • Members
  • Punkt
  • 7 Beiträge

Geschrieben: 14 May 2020 - 21:41

 
Hi
I am using version 3.2.2.
I imported about 40,000 products in 3 languages ​​to my shop.
I inserted them directly on Ms SQL database because importing with the CSV file takes a long time (about 3 days).
After importing data, any search on the search box takes a long time (about 13 seconds).
I did reindex on product and category tables.
Any suggestions to improve search speed?


#2 stefanmueller

stefanmueller

    SmartStore AG

  • Administrators
  • 458 Beiträge

Geschrieben: 18 May 2020 - 12:03

Hello mahdavi, please tell me which edition do you use.

 

When it comes to online shops with a large number and variety of products, the shop's basic search system often reaches its limits. Therefore, the key to success is to use a high-functioning, fast and intelligent search facility, like Smartstore MegaSearch / MegaSearch Plus.

 

The open source community edition comes with a basic database search. Thhat may not be enough for your project, so consider using:

 

The professional edition -- comes with MegaSearch feature for greater search speed on large catalogs.

 

The premium edition -- comes with MegaSearch Plus feature for greater search speed on large catalogs, facetted search and caching (< 0,5 sec on millions of products)

 

Please contact our sales team to discuss the right edition for your project.

 

https://smartstore.c...tore-megasearch

 

Greetings, Stefan


Stefan


#3 mahdavi

mahdavi

    Newbie

  • Members
  • Punkt
  • 7 Beiträge

Geschrieben: 18 May 2020 - 12:11

Dear Stefan,

 

Thanks for your reply. yes we use open source community edition .

I checked your SQL queries and I saw speed.

Is it possible, that we just buy and use your Mega search as a plugin in your community edition  ?

 

Best regards,

Mahdavi


  • stefanmueller gefällt das

#4 mahdavi

mahdavi

    Newbie

  • Members
  • Punkt
  • 7 Beiträge

Geschrieben: 18 May 2020 - 16:00

Thanks Stefan,

 

I am connected with your sales department.

 

BR

Mahdavi


  • stefanmueller gefällt das