Ooops! I think you are right Mark.
Staffan
On Tue, Oct 16, 2012 at 7:39 PM, Mark Miesfeld <miesf...@gmail.com> wrote:
> On Tue, Oct 16, 2012 at 10:28 AM, hakan <hexi...@users.sourceforge.net>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
> Oorexx-users@lists.sourceforge.net
> 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
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users
