#1 2013-07-02 04:58:12

julienf_logiCells
Member
Registered: 2013-06-07
Posts: 2

Improve performance

Hi,

i'm using big table as XML cache in my system.

And i have a performance problem.
I made some investigations with AQTime ans see that SynBigTable take 70% of the time of my process.
I need saving a group of about 300 XML blocks, but each record adds takes about 65ms.
Time is consumed by the Validate Method that checks constraints on the index String Field. [tfoIndex, tfoUnique].

The Method SortCompare is called about 4000 times and takes 5ms.

Is this the standard performance or i make something wrong ?
Because I use UniqueID, validation are not useful, could I bypass this function ?

Thanks,

Julien

Offline

Board footer

Powered by FluxBB