What about canonical

SELECT COUNT(*) FROM table;

?

27 August 2014, 16:51:23, Author "Mark Halegua" <phanto...@mindspring.com>
 
>   this may seem like a small issue, but I'm not sure if the solutions I've 
> found 
> on the web will do what I want in a low memory situation.I'd like to iterate 
> through a table one row at a time.  I can do that in pysqlite, but I don't 
> see 
> a method for determining I'm at the end of the file
> 
> Can anyone point me in the correct direction?  Again, it's a low memory 
> solution the the table could become quite large, so I don't want to load the 
> whole thing with a teychall() call, and I'm not sure if a cursor won't  take 
> up too much memory as well.
> 
> Thanks,
> 
> Mark
> 
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to