one or two databases

[Ruslan Zasukhin]

On 5/21/05 1:21 AM, "Robert Brenstein" <rjb at robelko.com> wrote:

Hi Robert,

> I am expanding my web application to store log of activities in the
> database. SO far log was written as a text file. I wonder whether it
> is more efficient to keep both data and log tables in a single
> database file or rather have each in its own file. Each involves
> multiple tables. Each involves regular reads and writes.

In theory this should not affect.

Note, that with 2 dbs you can put them on different HDD, and this fact can
improve your speed.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]