Here it is one patch and one file to remove all statements and SQL
queries from db.c file.
Statements are now a gchar* table named DbStatement (db_private.h).
GHashTable is also removed (less memory consumption) and
db_prepare_stmt is called on each statement call.
Most of SQL queries are in another table (DbQuery). The db.c code is
much more readable.
To get a statement you should write: DbStatement[myStatement]
To get a SQL query you shoud write: DbQuery[mySQLQuery]
Both myStatement and mySQLQuery are integers declared in two enumerations.
Some queries are merged : index creations, drop triggers, etc.
I'm sorry for the delay. I have my job and those modifications were
tested during a week long.
If this patch is accepted, I'll start working to split comment from
items and I'll do some db improvement.
If this path is not accepted, I'll start working to split... :)
From: Lars Lindner <lars.lindner@gm...> - 2012-04-25 09:08:32
On Mon, Apr 23, 2012 at 2:09 PM, Régis FLORET <r.floret@...> wrote:
> I rebuilt the project after a "make distclean" I've forgotten to remove few
> Here's the definitive patch
Thanks for contributing these patches. I hope to be able to check them soon.
But it might take awhile. If in doubt don't hesitate to nag about it!