many thanks
Seamus
At 12:47 PM 17/08/00 , you wrote:
> >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/[email protected]/
>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.
Seamus Campbell BookBusiness - Netinfo
www.bookbusiness.com.au [EMAIL PROTECTED]
ph 02 6297 4883 fax 02 6297 8464 mob 0416 055 171
In the Book Business? You need BookBusiness!
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.