[asterisk-users] MYSQL problem

[Zhang Shukun]

2010/1/27 Steve Edwards <asterisk.org at sedwards.com>:
> Un-mid-posting...
>
>>> On Fri, 22 Jan 2010, Zhang Shukun wrote:
>>>
>>>> as you know, we can use MYSQL command to visit mysql database but if i
>>>> use other database like Oracke,sybase,etc, Could i use MYSQL command ?
>>>
>> 2010/1/23 Steve Edwards <asterisk.org at sedwards.com>:
>
>>> ODBC will do what you want.
>>>
>>> Personally, I'd vote for an AGI using whatever C API your DB provides
>>> -- like Pro*C to access Oracle.
>>>
>>> You will have access to all of the features of your DB and your
>>> dialplan will be a lot cleaner and easier to maintain.
>
> On Wed, 27 Jan 2010, Zhang Shukun wrote:
>
>> Thanks, while i think because oracle has no offical ODBC for linux
>> system. is that better use mysql than oracle. considering the
>> perfoermace and speed. many people around think mysql is not a good
>> option for database, they think mysql is only suit for small business.
>> but i want to have a try. i need to convince them to use this.
>
> So don't use ODBC, use Pro*C...

you said" Personally, I'd vote for an AGI using whatever C API your DB provides"

what do you think about phpagi and cagi, if i choose the agi method.

while phpagi seems used more popular than cagi.

>
> Back when Yahoo was relevant, they ran on MySQL.
>
> Can you quantify your requirements (number of rows, queries per second,
> simultaneous connections) and test it on hardware similar to your
> production environment?

i cant quantify my requirement now. but the business has not be start.

and the user will increase as time going.

>
> While I'm sure Yahoo spent a lot of time and money designing and tuning
> their system, sometimes "explain plan" can point you to small changes that
> yield significant results.
>
> If your shop is committed to Oracle, can finance the licenses, and has the
> in-house talent -- use it. Nobody ever lost their job by buying IBM...

>
> --
> Thanks in advance,
> -------------------------------------------------------------------------
> Steve Edwards       sedwards at sedwards.com      Voice: +1-760-468-3867 PST
> Newline                                              Fax: +1-760-731-3000
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>



-- 
Best regards,
Sucan