Re: [sqlite] Re: what is faster?

2006-04-18 Thread michael munson
The file opening and connect overhead would make your strange idea slower almost definitely if you use many tables. Cesar David Rodas Maldonado wrote: any one can answer me? On 4/15/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: Hello I have a software that uses four tables.

Re: [sqlite] Re: what is faster?

2006-04-15 Thread Nathan Kurz
On Sun, Apr 16, 2006 at 02:23:45AM -0300, Cesar David Rodas Maldonado wrote: > On 4/15/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > > > Hello > > > > I have a software that uses four tables. > > > > that's ok.. but i wanna know if is faster if i use for every table a > >

Re: [sqlite] Re: what is faster?

2006-04-15 Thread Jim Dodgen
The idea of putting a table per database is a little odd, I expect that is why you did not get an instant answer. typically database table are interrelated and therefore need to be joined to provide useful information. Given that there are some good reasons why you might want to keep some