Speed benefit calling source db from query?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rico - 11 Jan 2006 22:10 GMT

Hello,

Is there any performance advantage to calling out the SourceDB in a query as
opposed to using the table attachments in a database?

Thanks!

Reply to this Message

Tom van Stiphout - 12 Jan 2006 01:11 GMT

Have you noticed any?
Run the two queries side by side, and let us know how you fare.

-Tom.

>Hello,
>
>Is there any performance advantage to calling out the SourceDB in a query as
>opposed to using the table attachments in a database?
>
>Thanks!

Reply to this Message

Rico - 12 Jan 2006 17:06 GMT

Well, if I had a 20 point network to test it out on I wouldn't be here
asking that question. I know there doesn't seem to be any performance
difference on a stand alone machine, or even on my home network, but I'm
planning on remotely deploying a program to a site that has twenty
workstations (roughly) and may even be a 10baseT hub or switch, so any
performance help I can get would be appreciated.

Thanks.

> Have you noticed any?
> Run the two queries side by side, and let us know how you fare.
[quoted text clipped - 8 lines]
>>
>>Thanks!

Reply to this Message

Tom van Stiphout - 13 Jan 2006 03:04 GMT

Generally you'll probably see little difference. Linked tables are
much more commonly used, so probably better supported.
Have you seen this page:
http://www.granite.ab.ca/access/performancefaq.htm
Some of its suggestions would likely make a much bigger difference.

-Tom.

>Well, if I had a 20 point network to test it out on I wouldn't be here
>asking that question. I know there doesn't seem to be any performance
[quoted text clipped - 17 lines]
>>>
>>>Thanks!

Reply to this Message