RE: 1 or more dsn's - efficiency?

2000-08-16 Thread Seamus Campbell
Slightly off the original topic, but Is there any speed or efficiency loss/gain in using one database (with many unrelated tables) in one website - compared to using many small databases and therefore many datasources eg a bookshop has a data for books daily quotes links Books is the main databa

RE: 1 or more dsn's - efficiency?

2000-08-16 Thread rkeniger
>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 syst

RE: 1 or more dsn's - efficiency?

2000-08-16 Thread Seamus Campbell
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. Maki