big table

[Ruslan Zasukhin]

On 6/4/04 8:16 PM, "olivier vidal" <vidal_olivier at yahoo.fr> wrote:

> 
>> 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.

But have you specify bigger cache size ?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------