Thanks Steffan, This is a great suggestion and I would doubt the
performance would be very detrimental to using individual step
statements. I am very much a novice on the object usages with
ooRexx, so this is a good excuse for me to learn more on array of
arrays, and directories. None of my queries would ever result in
more than 1,000 rows unless something is really messed up.
Art
> This limitation in SQLite is one of the reasons why I hardly ever
> step through the rows in my program. Instead I do an ~exec("SELECT
> whatever") using an array of arrays as output, and I can get the
> count using resultArray~items minus 1. The performance is very good
> even though an array of directories would suit me better
> (unfortunately the overhead is twice that of array of arrays). OK,
> this works fine for the data that I'm using which seldom reaches
> more than 500,000 rows. If you are dealing with very large
> databases then perhaps stepping is the only practical way to do it.
>
>
> Staffan
--
Art Heimsoth - artst...@artheimsoth.com
--
Art Heimsoth - artst...@artheimsoth.com
------------------------------------------------------------------------------ Android is increasing in popularity, but the open development platform that developers love is also attractive to malware creators. Download this white paper to learn more about secure code signing practices that can help keep Android apps secure. http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________ Oorexx-users mailing list Oorexx-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oorexx-users
