vTable.AddRecord

[Infinity Development Team]

I didn't try that but I did remove the IndexbyWords in favor just a standard Index. That seemed to solve the problem entirely. It also sped up import by a factor of five.

Thanks for the help
Matt

"Barry G. Sumpter" <barrysum at bigpond.net.au> wrote:

>Did you run your test thru valentina studio?
>If it takes just as long then we know it’s the DB and NOT your code, etc.
>
>If you have the 4 files database then delete the .ind file.
>And test again.  The .ind will be recreated automatically.
>
>Otherwise, clone the db and use the new db to test against.
>
>Still, moving too slow then export the db (data and table structures) as
>SQL.
>Create a new DB and import the SQL (data and tabel structures).
>Then test against the new DB.
>
>hth
>
>Thanks,
>      Barry G. Sumpter
>
>
>
>
>-----Original Message-----
>From: valentina-bounces at lists.macserve.net
>[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Matt Milano
>Sent: Wednesday, 14 April 2010 1:13 AM
>To: Valentina Developers
>Subject: Re: vTable.AddRecord
>
>Hi Ruslan,
>
>Thanks for the reply...
>>
>> * check your cache size for Valentina
>
>Right now I have the cache set to (an admittedly low) 10MB. However, I've
>tried setting it as high as 300MB with no discernible difference.
>
>>
>> * what about indexes count?
>>
>> *  how many fields are indexed?
>>
>> *  does exists index by words?
>
>All the text fields are indexed. The two fields that email that email
>bodies are saved in, as well as the subject fields, are both Indexed and
>IndexedByWords.
>>
>>
>> * what size of TEXTs you insert?
>>
>>
>> E.g. If you insert EMAIL letter with 1000 words,
>> And field is IndexedByWord, then engine must do in fact 1000 INSERTs.
>
>If this is the case, why would it make a difference when saving to
>mailboxes/databases that only contain 1,000 - 10,000 records? It only
>seems to happen with the one containing 100,000 records.
>
>
>Thanks again.
>
>
>>
>>
>>
>> --
>> Best regards,
>>
>> Ruslan Zasukhin
>> VP Engineering and New Technology
>> Paradigma Software, Inc
>>
>> Valentina - Joining Worlds of Information
>> http://www.paradigmasoft.com
>>
>> [I feel the need: the need for speed]
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina