Jerome Alet <[EMAIL PROTECTED]> wrote: > > SQLite is way faster than the two other databases at least when the > number of records is reasonable, but when the database reaches > around 300 Mb which is something like 4000000 records in Table3, > it slows down dramatically (in fact the slowdown is probably from > the beginning, but becomes noticeable around 250 / 300 Mb), > and disk I/O becomes the bottleneck since the top command > gives me "wa: 90%" (if I understand correctly). > > I haven't noticed such a slowdown with PostgreSQL or MySQL. >
I'm really curious to know how PostgreSQL and MySQL avoid this thrashing problem. Does anybody have any insight on this? -- D. Richard Hipp <[EMAIL PROTECTED]>
