[sebxx4]

I'm using threaded queries in my plugins bacause it doesn't lags the server. But every query makes a new connection to the database. And my database has limit of 500 connections per hour. Usually it's enought, but sometimes it exceeds this limit and the hosting blocks any new connections for some time.

I tried to ask my hosting if they can increase this limit, but they answeared no. So, is there any way to do threaded queries using single connection to database?

[lexzor]

show code

[sebxx4]

Well, there's nothing to show. Just standard thread query.

[lexzor]

so you want to say you have limited amount for sending queries? or why your plugin make a new connection to the database at every query?

[bigdaddy424]

do multiple jobs on the same query.

[sebxx4]

Originally Posted by lexzor so you want to say you have limited amount for sending queries?

No, for connections per hour.

Originally Posted by lexzor why your plugin make a new connection to the database at every query?

I donno. Isn't it how the SQL_ThreadQuery works?

Originally Posted by bigdaddy424 do multiple jobs on the same query.

How on threaded queries?

[sebxx4]

Anybody?

[Bacardi]

Doesn't it work, if you connect once in database when plugin load,
store handle of that connection (you have now connection open all the time)
You can do many queries as you like.

When you delete handle, you lose connection.

Of course, don't connect multiple times, if you not delete handle. Or you have multiple connections open.

[sebxx4]

Yes, I use SQL_MakeDbTuple only once in plugin_init() in all of my plugins. So, SQL_ThreadQuery doesn't make new connection, only the query?

[Bacardi]

Maybe you mixing connetions with queries, of that 500 per hour limit.

Tell what host/product you are using which does have that limit ?