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.com> wrote:
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