[asterisk-users] MYSQL queries from dial plan

[Neeraj Chand]

Hi all, 

I currently run small scale mysql queries from the dialplan 

exten => s,n,MYSQL(Connect

exten => s,n,MYSQL(Query resultid ${connid}

exten => s,n,MYSQL(FETCH fetchid

exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${connid})


This currently takes about 4 seconds to complete.

If I run two simultaneous queries, this goes up to about 9 seconds for
both queries to complete. 

Is there a way that I can bring this time down? 

What sort of time delays are there if I use func_odbc? 

Thanks, 

Neeraj