| Author |
Ascii file reading
|
|
| bnelson@harbornet.com 2006-07-28, 6:55 pm |
| Every once in a while I have the need to read an ASCII file. The read
rate is miserable. I have tried all my magic. Access = open, buffers =
10000, quickscan. If I am dealing with a large file I end up using
something like FoxPro to read the file. How can I perk up the read rate
of an ASCII file?
| |
| bnelson@harbornet.com 2006-07-28, 6:55 pm |
| I found a work around. I define the file with a record length of 32k
and then do my own parsing to peel out the real records. Crude but
effective - works 100 time faster.
| |
| Olivier Cretey 2006-07-29, 6:55 pm |
| Read-Only ?
Regards
--
Olivier Cretey
o.cretey@cia-informatique.com
www.cia-informatique.com
Verneuil sur Seine (78), France
| |
| bnelson@harbornet.com 2006-07-29, 6:55 pm |
|
Deny all
| |
| Olivier Cretey 2006-07-30, 7:55 am |
| bnelson,
I think you may try the read-only mode, instead of the deny all mode.
I've seen huge differences reading text files.
From another side, setting the record buffer (record length) to align
with the hard disk cluster size is a good idea, but may be dependent
from the hardware... I mean your customer's cluster size may be not the
same as yours.
Hope it helps,
Regards
--
Olivier Cretey
o.cretey@cia-informatique.com
www.cia-informatique.com
Verneuil sur Seine (78), France
| |
| bnelson@harbornet.com 2006-07-31, 7:06 pm |
|
Yeah, I am using read only. Still in the mud
Bob
|
|
|
|