Speed benefit calling source db from query?

[Rico]

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!

[Tom van Stiphout]

On Wed, 11 Jan 2006 22:10:08 GMT, "Rico" <r c o l l e n s @ h e m m i
n g w a y . c o mREMOVE THIS PART IN CAPS> wrote:

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!

[Rico]

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.
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:l5********************************@4ax.com...

On Wed, 11 Jan 2006 22:10:08 GMT, "Rico" <r c o l l e n s @ h e m m i
n g w a y . c o mREMOVE THIS PART IN CAPS> wrote:

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!

[Tom van Stiphout]

On Thu, 12 Jan 2006 17:06:16 GMT, "Rico" <r c o l l e n s @ h e m m i
n g w a y . c o mREMOVE THIS PART IN CAPS> wrote:

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
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.
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:l5********************************@4ax.com.. .

On Wed, 11 Jan 2006 22:10:08 GMT, "Rico" <r c o l l e n s @ h e m m i
n g w a y . c o mREMOVE THIS PART IN CAPS> wrote:

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!