V4RB2 bug 648, new system of catch error

[Olivier]

Hi list,

This bug is important and slows down ENORMOUSLY all the operations of 
Valentina as soon as an exception (an error, a doubloon...) is caught.

We do not know if it is the system of error of Realbasic that is the 
cause or if it is a problem of Valentina.
Does anybody know enough the database of Realbasic to make a small test?

It would be necessary to add for example 30 000 records WITHOUT 
doubloons in a base and to measure the performance.
And redo a test by adding 30 000 records but this time with for example 
5000 doubloons (among 30000) and measure the performance.
In the second case, It is necessary to catch the generated error every 
time we try to add a doubloon.
Are the performances very different?

Naturally, the test is to be made on a field with a "unique" parameter.

thank you

olivier

>>
>> Did you look at the bug 648? ( V4RB)
>
> I think this is REALbasic issue.

>> In my example (see mantis), if I makes an import, for example of 80 
>> 000
>> records, but that there are 2000 identical records, while the "unique"
>> parameter is enabled, the operation will take dozens supplementary
>> minutes! (Because of the catch of error)
>
> Well, try to make REALbasic function without Valentina and bench how 
> many
> you can raise - catch exceptions in the REALbasic.
>
> If you prove that this is RB issue, then bomb REAL on that.
> If you will find that RB itself can do 100 times more exception than
> Valentina can do then we have 2 possible cases
>
> 1) exceptions from plugins are slow
>
> 2) problem in Valentina kernel.
>
>
>> If I remove the new system of catch of error and what I puts back the
>> old, everything is fast and there is not problem anymore.
>
> Right, so you have workaround.
>
>> There is a solution? Or it is necessary to use the old system of error
>> to increase the performances?
>
> May be, although this is bad of course.
>
> Exception should not add significant overhead.
>
> We need find WHO cause problems
>
>
> -- 
> 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
>