how to improve the speed of reading from access using dao

L

lh

i want to read and write blob data from access2002 using dao3.6, but i found
it is slower than ado. As i know, reading access with dao is the best way,
what happens?
i want read a table with 150000 rows wthin 2 secondes,which contains blob
field and every blob approximately is 150 bytes.

What can i do, improving the speed of i/o read and write or improving the
number of page buffer bool ?

Any idea is appreciated.
 
T

Tony Toews

lh said:
i want to read and write blob data from access2002 using dao3.6, but i found
it is slower than ado. As i know, reading access with dao is the best way,
what happens?
i want read a table with 150000 rows wthin 2 secondes,which contains blob
field and every blob approximately is 150 bytes.

What can i do, improving the speed of i/o read and write or improving the
number of page buffer bool ?
Click to expand...

Are you saying you want to do 150 K reads in two seconds. Or locate
any one record in that 150 Kb and read it?

If the former probably not going to happen as that would depend
greatly on factors outside your control such as network speed, ie you
might need GB LAN and not 100 mbps. If that would even be sufficient.

If the latter then how is your indexing on the fields when doing the
searching?

What are you using for searching anyhow? DLookup? Kinda slow.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
L

lh

Thanks your anwser.
My access database is local, and what i want is to read 150k data within 2
second with full scan, which means i need not any index and LAN.
I ever saw a software which has the performance.
When the software run, i find that it owners 270 paged pool and its I/O is
11M/s. How can it do?
Thanks!
 
T

Tony Toews

lh said:
My access database is local, and what i want is to read 150k data within 2
second with full scan, which means i need not any index and LAN.
Click to expand...

Being local will help. You want to read the 150K records in some
sequence. Therefore the fields used to determine that sequence should
be indexed.

Why do you want to read so many records in such a short time? How
long does it take to read so many records now. Would possibly a RAM
drive be faster? Although, clearly if there's a power failure or the
system locks up you will lose the data.

You might also want to try very fast hard drives. But will this gain
you enough performance I don't know.

Also compact the MDB before running.
I ever saw a software which has the performance.
When the software run, i find that it owners 270 paged pool and its I/O is
11M/s. How can it do?
Click to expand...

Not sure what you mean here.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top