On Sat, Oct 20, 2012 at 12:33 PM, hakan <hexi...@users.sourceforge.net>wrote:
> Yeah that what I meant by "OO_ARRAY_OF_ARRAYS" some wrong wording from my
> side, I know
> about ColumnName / columntext.
> I have tried sql statements with :aname or ?1 or etc and then bind a value
> to that parameter with ~bindtext as I think I get a performance gain by
> doing so, part of the sql is already "compiled" by sqlite and it would be
> conveniant to get the result back as directory object for each step.
> As I followed the conversation about "performance observation..." I
> realized that creating the directory objects with (~exec) current
> implementation take some resources, I have tables with ~300 000 rows and
> ~10 columns, and wants to have the convineance of using the directory
> objects as reference to the returned row together with the ~bindtext
> possibility, less changes to some existing code I have :-).
>
Håkan, currently ooSQLite mostly just provides a one-to-one means of using
each SQLite API. If you wanted each row returned as a .directory object,
you could write a wrapper that used step and built the .directory object
for you.
There is no reason that some type of convenience method could not be added
to ooSQLite to do that for you. But, since I don't really have any
existing database experience, I don't really know what types of convenience
methods to add. ;-(
That's why I was hoping that people with database experience would try
using ooSQLite, even though it is not ready for release, and give some
feedback through one of the mailing lists. So I could start getting some
idea of what convenience methods would be useful.
--
Mark Miesfeld
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
Oorexx-users mailing list
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users
