More Speed in SQL?

[Ruslan Zasukhin]

On 5/15/04 6:39 PM, "RyHoRuK" <RyHoRuK at gmx.de> wrote:

>> What cache size you have? Try 8-15-20MB
> 
> Err=ValentinaInit(1*1024*1024,VC,"")
> 
> 
> Err=ValentinaInit(5*1024*1024,VC,"")
> meineDatenbank.TAnzeige.DeleteAllRecords
> --> 0,05sec
> 
> First SQLString-Building with InserINTO
> --> 0,4-0,5sec
> 
> Second SQLString-Building with InserINTO
> --> 0,2-0,3sec
> 
> 
> Err=ValentinaInit(10*1024*1024,VC,"")
> meineDatenbank.TAnzeige.DeleteAllRecords
> --> 0,05sec
> 
> First SQLString-Building with InserINTO
> --> 0,2-0,3sec
> 
> Second SQLString-Building with InserINTO
> --> 0,02-0,08sec
> 
> *hmm* it seems that this will help. I am not sure why my actual setting
> is 1MB.
> 
> Thanks for help

    1MB 

This is the minimal possible.

8-20MB is the best choice for Valentina  1.x


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