[Kamailio-Users] avpops OR sqlops

alex pappas rebel.pappas at gmail.com
Mon Dec 21 21:00:42 CET 2009


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 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/users/attachments/20091221/c1467f14/attachment.htm>


More information about the Users mailing list