Have a critical issue with adding customer:
System info: Joom 2.5.4 + VM 2.0.6 + PHP 5.3.1 + VMInvoice 2.12

In my testversion with a few customers - works without problems regarding adding a customer in "create new order"

BUT - when I use the test version with 7000 customers in database:

- sometimes everything freeze - cant even click cancel
- sometimes when i type a name - the listbox apears after 2-5 minutes
- when the dropbox finally appear - it freezes for minutes if I change name

Guess the dropbox needs a huge amount of resources choosing from 7000 customers that way !
Tried to change cache size

Is it possible to add a customer another way ???
Or is there a way to allocate more resources for this event ???

Hello. Yes, you're right, 7000 customers may consume large amount of resources.

Solution would be adding indexes to database. I noticed that virtuemart don't have indexes on users's table, so adding them may improve dramatically search time.

Table (prefix)_virtuemart_userinfos needs add index to:
address_type
virtuemart_user_id
last_name

And then combination of fields
last_name
first_name
company
city
address_type_name

If you don't know how to accomplish this, send us your admin + mysql admin access to This e-mail address is being protected from spambots. You need JavaScript enabled to view it and we can check the problem for you.

Hi - Thx, try to take a look - a little scarred doing this - have to sync databases from OsCommerce.

- and afraid if the below will work:
Massmail, VM user edit, VM orders, Joom user manager, Acymail, onpage checkout, report manager etc.etc.

Sure theese will work if I add indexes / alter databases ???

BTW - have the same mild issue with many products, but only 500 !

Hi, if you are having this problem also with products (and 500 is not that many), it can be some other problem. We will need admin credentials to check problem on place.

Indexes: They really cannot harm you. It's not altering database structure, just marking some fields to be faster to search in, join or order by them. It doesn't change structure of database and doesn't have any requirements for current SQL queries.

Hi - Thx
- VMinvoice works perfect now adding indexes :o)
( and clears a lot off weird random issues due to freeze :o)

In VMinvoice Admin:
"start typing customer or company name or customer city."

Outstanding how many users who have the same name....

Don´t seem to search in "virtuemart_user_id" field

Can U give me a clue how to search either "virtuemart_user_id" or "phone_1" ???
- would be an awesome improvement :o)