big table

[Ruslan Zasukhin]

On 6/3/04 5:01 PM, "olivier vidal" <vidal_olivier at yahoo.fr> wrote:

> Hi list,
> 
> As joints are sometimes a little bit lengthy, I am tempted to use big
> tables.
> 
> To have many columns ( 200 ) in a table reduces the performances of the
> database?
> (The size of the database is not a problem).

I will not recommend to use with Valentina table with so many fields.
Because Valentina keep fields in separate files.

For OLAP tasks this still can be good.
E.g. One developer have use 1000 fields tables.
He have stable set of records and just do searches and sorting,
For such tasks Valentina is hundreds times faster of others.

If you can split table then split it.


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