speed of importing

Ruslan Zasukhin sunshine at public.kherson.ua
Tue Jan 4 16:55:04 CST 2005


On 1/4/05 4:38 PM, "jda" <jda at his.com> wrote:

>> So problem NOT in the cache overhead.
>> 
>> 
>> Hmm. This db must be able created in 1 second ideally.
>> 
>> With indexing longer of course. You have big texts.
>> Each record means adding about 1000 points into indexes.
>> 
>> So it looks like you have db in 400,000 records.
>> 
>> But still...
>> 
> 
> I turned OFF indexing and imported these 1000 records -> ~ 120 seconds
> 
> With indexing ON -> ~ 112 seconds
> 
> (times are approximate, so I'd say there was no difference).

I think that Valentina self set them ON on some reason.
I do not see reason why.

Only if a field is marked unique

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




More information about the Valentina-beta mailing list