big table

olivier vidal vidal_olivier at yahoo.fr
Fri Jun 4 19:16:15 CDT 2004


> but in my tests (with it is true few recordings), my database is 
> faster (in reading) with a table of 150 columns than with 10 tables of 
> 15 columns. Join them are a little bit slow in that case.

The POS softwares is often installed on small specialized PC. This 
small PCs often has slow hard disks 2 " 1/2. It is for it that join 
them are slow I think, the hard disk slows down the operation a lot. In 
my tests, I noticed that a big table was faster because it sought less 
the hard disk.



More information about the Valentina mailing list