By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,870 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,870 IT Pros & Developers. It's quick & easy.

Speed benefit calling source db from query?

P: n/a
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!
Jan 11 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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!


Jan 12 '06 #2

P: n/a
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!

Jan 12 '06 #3

P: n/a
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!


Jan 13 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.