>I'm not sure I understand the problem. You have almost one milion records and 6 seconds is to long?
>
>Ron
>
>>I have a table with over 900,000 records in it.
>>takes 5 to 7 seconds (about the same time it takes to browse the table).

I guess that is part of my question... Do I have unrealistic expectations? How fast should I expect this to be?