Hi
Never really noticed this before, I know there is overhead with BE on local network (gigbit) but I have large tables with 10000+ records & a get minimal slow down really.
However I have a BE table of only 5 records, lookup of rates depending on a dates range.
I am testing as noticed in Dlookup in a query was very slow (I know not the best & can be slow but on 5 records I figure OK)
So test on a loop 100 times.
just Dlookup searching through these 5 records each time.
Takes 1.8 seconds
If I do the same test on a larger table I have, 3800 records, similar dates etc.
takes 1.8 seconds !!
so assume the time taken is really just accessing the BE on the network & not looping through.
If I make the 5 record table local
test takes 0.06
Thinking about it I guess it has to re-access in case data has changed.
Any ideas/advise
I can copy to a local table at the start of each day as not going to change very often.
Just seems messy
Never really noticed this before, I know there is overhead with BE on local network (gigbit) but I have large tables with 10000+ records & a get minimal slow down really.
However I have a BE table of only 5 records, lookup of rates depending on a dates range.
I am testing as noticed in Dlookup in a query was very slow (I know not the best & can be slow but on 5 records I figure OK)
So test on a loop 100 times.
just Dlookup searching through these 5 records each time.
Takes 1.8 seconds
If I do the same test on a larger table I have, 3800 records, similar dates etc.
takes 1.8 seconds !!
so assume the time taken is really just accessing the BE on the network & not looping through.
If I make the 5 record table local
test takes 0.06
Thinking about it I guess it has to re-access in case data has changed.
Any ideas/advise
I can copy to a local table at the start of each day as not going to change very often.
Just seems messy