>That sure sounds like a very long time. Is the data on the same machine or is it fetched over the network?

*Network

>Is there a noticable difference if you select data from a different month?

*No

What if you drop the order (you can always sort the dataset after it is populated)?

*No difference

>
>Out of curiosity how long does it take in VFP?

*a fraction of second 

>
>Einar
>
>>There is a free VFP table containing about 0.5 million records. It is indexed and in VFP it takes a fraction of second to get a result from statement like:
>>

>>SELECT * from table_name where TTOC(indexed_field,1) = “200510” ORDER by 1
>>

>>
>>The problem is that I cannot achieve the similar performance in Vb.NET where I use the code below to fill the data adapter:
>>

>>
>>Me.OleDbSelectCommand2.CommandText = _
>>"SELECT * FROM table_name WHERE (TTOC(indexed_field,1) = '200510’) ORDER by 1"
>>
>>Me.OleDbDataAdapter2.SelectCommand = Me.OleDbSelectCommand2
>>Me.OleDbDataAdapter2.Fill(Me.DataSet21)
>>

>>
>>It takes 1 - 2 minute to get the result. Am I missing anything here, or do I need to make specific settings somewhere?
>>
>>If this approach does not support Rushmore technology, then what could be the alternative way?
>>
>>
>>Thanks in advance for your help.