>Hi,
>
>I'm trying to make a searchform where Ithe user can serach for a customer on muliple fields at the same time (fields are phonenumber, name, adresse, zipcode...)
>
>If I make a select statement with all these fields in it - the query takes up to 30 seconds og at table with 350000 records. How can I optimize this searchtime ?
>
>
>Regards,
>
>Kenneth Ingebrigtsen
I do NOT recommend placing indices on all fields, only on fields that have many different values. If you do have indices on all fields, you may need to disable some of them temporarily. See my FAQ #8109, for hints on optimizing queries.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)