I make use of group_concat aggregate function and I found
it very slow, especially when there are thousands of lines per group.
This is because it reallocates memory on each processed row.
I changed just one line in sqlite3StrAccumAppend():
szNew += N + 1
to something like this:
do{ szNew = szNew*2 + 1; } while (szNew <= p->nChar + N);
and now group_concat works fine.
Would the authors be kind to implement such optimization?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
