vTable.AddRecord

[Barry G. Sumpter]

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