> In case Staffan's solution was a little obscure to you, when he says: you
> can do a SELECT COUNT(*) ...
>
> I think what he means, and he can correct me if I'm wrong, is to add the
> count to your SELECT statement. Not use 'SELECT COUNT(*);' exactly. So if
> you were going to do for instance:
>
>
You are correct as always. My answer was a bit short I realise.
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
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/oorexx-users
