vTable.AddRecord

[Ruslan Zasukhin]

On 4/13/10 10:01 AM, "Matt Milano" <lists at infinitydatasystems.com> wrote:

Hi Matt,

> I've just switched to using Valentina, and I'm having an issue that I'm
> sure is probably easy to resolve.
> 
> Basically, I'm using the SQL method, and saving records to a database that
> currently contains roughly 100,000 entries. I seem to be experiencing some
> significant lag with the AddRecord method of the Valentina table. It can
> take as long as 3 or 4 seconds to actually add the new record. This
> doesn't happen when saving records to smaller databases, only the large
> one.
> 
> The database has 21 fields...
> 
> TextField - 14
> MediumField - 6
> DoubleField - 1
> 
> Any help would be greatly appreciated.

* check your cache size for Valentina

* what about indexes count?

*  how many fields are indexed?

*  does exists index by words?


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



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