big table

[Ruslan Zasukhin]

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

> The requests :
> 
> SELECT a.name, b.name, c.name, d.price
> FROM boProduct a, bo_price d, boSortPrice b, boSortStore c ,
> bo_product_sortstore_sortprice_price
> WHERE a.RecID=1
> 
> and
> 
> SELECT a.name, b.name, c.name, d.rate
> FROM boProduct a, bo_sort_vat b, bo_sort_store c, bo_vat d,
> bo_product_sortvat_sortstore_vat
> WHERE a.recID=1
> 
> 
> The requests work slowly.

Hmm, you __see__ that it works slowly on 12 records only ???

Something wrong. There was developers which have do joins on 20 tables and
the say they it fast.

Try set cache 15MB


> If I modify my database in a not very academic way... :
> 
> BO_PRODUCT
> -Name
> -Price_1_Store_A
> _Price_2_Store_A
> _Price_3_Store_A
> _Price_4_Store_A
> -Vat_1_Store_A
> _Vat_2_Store_A
> -Price_1_Store_B
> _Price_2_Store_B
> _Price_3_Store_B
> _Price_4_Store_B
> -Vat_1_Store_B
> _Vat_2_Store_B
> ...........................
> 
> 
> SELECT price_1_store_A, price_2_store_A, price_3_store_A,
> price_4_store_A...........
> FROM BO_Product
> 
> The request works very quickly!

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