Ooops! I think you are right Mark.
Staffan
On Tue, Oct 16, 2012 at 7:39 PM, Mark Miesfeld <[email protected]> wrote:
> On Tue, Oct 16, 2012 at 10:28 AM, hakan <[email protected]>wrote:
>
>> **
>>
>> I have these figures on win7 64 with 8Gb of memory and Intel i3 2.13GHz
>>
>> C:\MyPrograms\MyRexx\work\ooSQlite\pgm>runtest.rex
>> 4.340000
>> 14.610000
>> 25.100000
>> ...
>>
>>
>> db1=.oosqliteconnection~new("./large.db")
>>
>> db1~recordformat = .oosqlite~OO_ARRAY_OF_ARRAYS
>>
>> x = time("E")
>> rows1 = db1~exec("SELECT * FROM TBL1", .TRUE)
>>
>> say time("E")
>>
>> db2=.oosqliteconnection~new("./large.db")
>> db2~recordformat = .oosqlite~OO_ARRAY_OF_DIRECTORIES
>> rows2 = db2~exec("SELECT * FROM TBL1", .TRUE)
>>
>> say time("E")
>>
>
> Isn't this adding the times together. Don't you need to do a 'reset'
> before you collect the time for the second exec()? Same for the third
> exec()
>
> --
> Mark Miesfeld
>
>
>
> ------------------------------------------------------------------------------
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> _______________________________________________
> Oorexx-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/oorexx-users
>
>
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Oorexx-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oorexx-users
