var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Speed up string search?
I'm having a headache with the speed that search results are returning in one of my databases.
I have a database of 90k records and I let users search on a combination of contact_name, organisation and postcode.
my problem is that the underlying search queries have to let the users search by any part of the field ie like "*" & [contact_name] & "*".
I've put indexes on the table but still no improvement, anyone got any ideas?
Access XP & WinXP Pro