Re: [ossig] CA open-sources Ingres database - News & Technology -CNETAsia

[Lim Kheng Huat <khenghuatlim@xxxxxxxxxxx>]

hi,
 Yup, Imaran is right, start from MySql 4.1 supported all form of 
subquery. http://dev.mysql.com/doc/mysql/en/Subqueries.html

About store procedure only available on version 5
http://dev.mysql.com/doc/mysql/en/Stored_Procedures.html
Bottom of heart, MySql is the best among the open databases.

Current production is MySQL 4.0




Imran William Smith wrote:

> Lim Kheng Huat wrote:
>
>> hi all,
>> Does anyone know which database more reliable, better performance 
>> (Mysql, Postgresql or Ingres) ?
>> I know that current mysql version lack of features such as sub-query, 
>> store-procedure (i guess will improve it all in version 5) Anything 
>> to share?
>
>
> I believe MySQL has had subqueries for a long time now, and I
> think they might have stored procedures.  They also have clustering
> in their latest version.  In terms of adding features, MySQL seems
> fastest.  According to the speech given by David Axmark at
> FOSSCON2003, MySQL has never had any significant complaints about data 
> loss that could be attributed to the database (as long as you use 
> stable, not alpha or beta versions).
>
> Imran
>



---------------------------------------------------------
To unsubscribe: send mail to ossig-request@mncc.com.my
with "unsubscribe ossig" in the body of the message