Hi,
first of all thanks for the great sqlops module.
Is "|sql_result_free(result)|" needed before I leave the script by "exit;" to avoid memory trouble or is it only needed to query again in the same request processing?
Is there any way to check if the query was not successful (db unreachable, systax error in query)? I've seen a warning in the syslog, but I need to check it in the script.
BTW in the doc the example for 1.4.2. seems to be wrong?
regards, Andreas
Hello,
On 03/08/2009 12:51 PM, Andreas Heise wrote:
Hi,
first of all thanks for the great sqlops module.
welcome!
Is "|sql_result_free(result)|" needed before I leave the script by "exit;" to avoid memory trouble or is it only needed to query again in the same request processing?
It is required to free the memory used by result. If it is not done, next query will do the free automatically. So, it is recommended to do it.
Is there any way to check if the query was not successful (db unreachable, systax error in query)? I've seen a warning in the syslog, but I need to check it in the script.
The function return false if the query was not sucessful.
BTW in the doc the example for 1.4.2. seems to be wrong?
Because of missing usage of sql_result_free()? Or you spotted something else?
Cheers, Daniel
Daniel-Constantin Mierla schrieb:
BTW in the doc the example for 1.4.2. seems to be wrong?
yes this was what I missed, I saw you already fixed it
Because of missing usage of sql_result_free()? Or you spotted something else?
Cheers, Daniel
what is known about the performance of sqlops? I use a single sql query for each initial invite request and use MySQL on the same machine with a table of ~5000 raws, what sould the maximum possible CPS with sqlops?
regards, Andreas
On 03/12/2009 05:51 PM, Andreas Heise wrote:
Daniel-Constantin Mierla schrieb:
BTW in the doc the example for 1.4.2. seems to be wrong?
yes this was what I missed, I saw you already fixed it
yes, I thought you may have spotted something else.
Because of missing usage of sql_result_free()? Or you spotted something else?
Cheers, Daniel
what is known about the performance of sqlops? I use a single sql query for each initial invite request and use MySQL on the same machine with a table of ~5000 raws, what sould the maximum possible CPS with sqlops?
I guess it is a matter of indexes and returned data. you can use benchmark module to see how long it takes the operation.
Cheers, Daniel
-
Andreas Heise -
Daniel-Constantin Mierla