On 4/2/2004 at 14:06, you wrote:
JL> Do querying two different databases from the same page use more
JL> resources and take longer that two querys of the same database? of
JL> is there no difference.
Probably depends on one or more of the following:
1. Does the application server cache the connection when the same
database is queried twice, or does it use two separate connections?
2. Are the databases local or remote? For remote, the quality of the
network connection would dictate how quick the results were returned.
3. What DBs are being used (MSSQL, MySQL, PostgreSQL, Access)?
4. The specs of the hardware running the DBs.
5. How well are the DBs and SQL statements optimized (e.g., column
indexes and join syntax, respectively)?
And so on and so forth :)
~ Ubqtous ~
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
