That didn't reveal anything more than that with nulls it goes faster:
2.496000
6.037000
10.187000
As there any sort of data conversion going on in ooSQLite? My real database
contains a mixture of text, dates, booleans, numbers, NULLs and nulls (text
with zero length), maybe something else I can't remember now.
Staffan
On Tue, Oct 16, 2012 at 7:05 PM, Staffan Tylen <staffan.ty...@gmail.com>wrote:
> Mark, some progress. Throughout I've used a 'real' database for testing
> this, but I now decided to create a test database just like yours and with
> that I get the following results:
>
> 3.744000 OO_ARRAY_OF_ARRAYS
> 11.201000 OO_ARRAY_OF_DIRECTORIES
> 19.126000 OO_STEM_OF_STEMS
>
> So why this difference? The major difference between the databases that I
> can think of is that the 'real' database contains a LARGE number of NULL
> values, while the test database doesn't have any. I will try to create a
> different test database that includes NULLs and see what happens.
>
> Staffan
>
>
>
>
------------------------------------------------------------------------------
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
