kayssun
24th April 2010, 22:26
Hi
I am heavily using QSqlQuery::prepare() in my application and since I have to process a lot of data, mysql throws an error: ERROR 1461 (42000): Can't create more than max_prepared_stmt_count statements (current value: 16382)
Can I somehow free these prepared statements? It is nice to use them, because I don't need to care how to escape variables when switching from MySQL to SQLite for example.
I know I could optimize my code to do less queries, but this would make it less readable? Do you have any ideas?
I am heavily using QSqlQuery::prepare() in my application and since I have to process a lot of data, mysql throws an error: ERROR 1461 (42000): Can't create more than max_prepared_stmt_count statements (current value: 16382)
Can I somehow free these prepared statements? It is nice to use them, because I don't need to care how to escape variables when switching from MySQL to SQLite for example.
I know I could optimize my code to do less queries, but this would make it less readable? Do you have any ideas?