On Tue, Oct 16, 2012 at 10:16 AM, Staffan Tylen <staffan.ty...@gmail.com>wrote:
> That didn't reveal anything more than that with nulls it goes faster:
>
> 2.496000
> 6.037000
> 10.187000
>
That's what I would have expected.
>
> 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.
SQLite converts the values to strings. This is done internally by SQLite
for the sqlite3_exec() interface. Which is what the exec() ooSQLite method
uses. Most, but not all, of the ooSQLite methods simply call the
corresponding SQLite interface.
--
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
