Large Files

[Jody]

I'm running code on three large files, first a while not
eof on 25,000 record file, within this a findrecord on
12,000 record file and then a fiind record on 150,000
file. Its incrediable slow, any suggestions on how to
speed up processing?

 

[John Spencer (MVP)]

Possibly, but since you have not shared your code, your table structure, or what
you are attempting to do - the only thing I can suggest is that you make sure
you have indexes on all the fields that you are searching or ordering by.

FindRecord is slow. Can you use an SQL query to get the necessary record into a
recordset? Again, without knowing your code, your table structure or you
purpose, I find it difficult to give you much in terms of concrete advice.

 

[JODY]

Thanks for that was in process od setting up indexes, but
now seek fails. How can a view the contents of the index
key so I can ensure my criteria is in correct format, in
VB.

 

[jody]

ok sorted!

-----Original Message-----
Thanks for that was in process od setting up indexes, but
now seek fails. How can a view the contents of the index
key so I can ensure my criteria is in correct format, in
VB.

searching
or ordering by. of
concrete advice.
.