Hi!
Can you send a query you use?
>Hi,
> I have try your suggestion. It take 2 secs to retrieve 20,000 records. Is ot ok? Again, I need to group it base on 2 fields. It take 4 secs. I feel it it too slow. Any ideas?
>
>Thank you
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.