Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Customer search query
(1 viewing) (1) Guest
Support forum for customers who have purchased this product. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Customer search query

Customer search query 12 years ago #35197

Hi. The customer search query in getter.php:getAjaxUserList is exausthing for the server! we have more than 2500 customers, and on every keypress (even with a single character) the query is performed, and on a DEDICATED joomla server it takes TWO MINUTES! IT's useless.

Two improvements:
* remove useless search fields (city, address_type_name). It would be great to have email in the search query as well, but being it not optimized still takes ages!
* execute the query after at least two characters has been entered, and after the user stopped typing for at least one or two seconds

thanks
The topic has been locked.

Re: Customer search query 11 years, 11 months ago #35563

  • pama
  • OFFLINE
  • Posts: 489
Hello. Thanks for your suggestions. We will implement it when we will have free time.
In mean time, you can try to add indexes to your VM tables. Indexes can dramatically improve search time in database (on the contrary, updating record can be little slower, but that is definitelly not an issue for you).
Namely to fields: first_name, last_name, address_type_name, company, city and address_type_name in table #__virtuemart_userinfos. Let us know if it helped you.
ARTIO Support Team
Last Edit: 11 years, 11 months ago by pama.
The topic has been locked.
  • Page:
  • 1
User Login Empty