[sqlite] Exception Problem - Heap

2009-02-14 Thread Pramoda M. A
Hi All, I am getting an exception/error after some data is retrieved. I have copied here the screenshot... After storing 250 rows of data, it is giving exception... How to use malloc functions efficiently? Please help me anybody... ___

Re: [sqlite] Full Table Read

2009-02-14 Thread Alexey Pechnikov
Hello! В сообщении от Saturday 14 February 2009 00:33:38 Nathan Biggs написал(а): > Is there a faster way to read an entire table other then: > > select * from table > > Not that is is slow, just curious. On linux you can do dd if=database.db of=/dev/null bs=1M and after perform "select ..."

Re: [sqlite] sqlite3 cmd line: arrow

2009-02-14 Thread David Easley
> Install libreadline5-dev before running configure. The readline > library is what provides the command line editing and recall. Thank you Roger - that fixed it. I've raised a minor ticket on the INSTALL document, suggesting it should mention this. David

Re: [sqlite] having the Top N for each group

2009-02-14 Thread Edzard Pasma
Hello, May be this is some idea: GROUP_CONCAT is a built-in aggregate function, that efficiently returns a list (as text) of items in each group. If you add ORDER By (before the group by) it also arranges the ordering. But it does not let you restrict the number of elements in each group, to

[sqlite] having the Top N for each group

2009-02-14 Thread Sylvain Pointeau
Hello all, I am wondering if we have a method faster then the INNER JOIN which can be very slow in case of large number of rows, which is my case. I was thinking of a UDF that increment a number if the concatenation of the key column (or group columns) is the same, means: select col1, col2,