Alex, What do you suggest for faster sql queries with mysqlp : avpops or sqlops ?
Cheers Alex
On Mon, Dec 21, 2009 at 9:55 PM, Alex Balashov abalashov@evaristesys.comwrote:
On 12/21/2009 02:51 PM, alex pappas wrote:
The column in ported table was BIGINT but sqlops and avops take only
string or int. I changed the colunm id table from BIGINT to INT and everything works fine! kamailio Rock's!!
Ah, yes, I have commonly run into this one as well. Yes, the database interface layers generally support only canonical scalar types - basic integer and varchar, as well as types that offer ready-made convertabiliy in a textual evaluation context (e.g. PostgreSQL boolean type, 't' or 'f').
No bigints unless you cast down to int. :)
-- Alex Balashov - Principal Evariste Systems Web : http://www.evaristesys.com/ Tel : (+1) (678) 954-0670 Direct : (+1) (678) 954-0671