>Books is the main database; should tables be added to this database for
>daily quotes and for links
>or
>is it better to have separate small databases for daily quotes and links
Definitely better to have it all in one DSN. Making an ODBC connection to a data
source is costly in terms of system resources, so minimise the number of DSNs as
much as possible. There is no problem in having unrelated tables in a database,
this is quite normal.
The other issue here is that many hosting providers will charge you per DSN you
set up so it will cost you three times as much to host your system should you
choose to set up 3 DSNs.
--------
Rob Keniger
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
