I have a database of over 100000 contacts / accounts
The time to search for contacts by account name is very slow (15 seconds).
This is on a Dual Xeon, 6GB Ram etc etc
I understand that the problem is because the acocunt name is not in the contacts table but must be linked via the accounts table.
Is there some way to speed this up as it is a very common search of ours.


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks