Mysql 5- ur views

spicy · #1 07-26-2006, 01:54 PM

Ok. so it has now been out for quite a while. does anyone have any opinoins on mysql 5? how does it compare to 4.x?

I am particularly interested in its performance. I have a sneaking suspiscion that it might actually be slower than mysql 4.x? anyone got any concrete knowledge on this?

Should i upgrade or not?

Please answer all my questions
Thanks for sharing your ideas -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

spencer1 · #2 07-26-2006, 01:59 PM

I have used it, mysql 5 is just as fast, but also supports fun things like triggers, stored procedures, views and partitions.

Think u should upgrade -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

glitch · #3 07-26-2006, 02:05 PM

I don't know about a performance, but the new features are great if you develop in myql/php. It will soon be as powerful as oracle and far more easier to use, which would ease lots of things very much.

Hope it helps your decision

-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

fleming · #4 07-26-2006, 02:09 PM

Sorry, but related question

Can anybody tell me how do you actually use mysql5 stored procedures from php?

Is the performance better with a stored procedure than a regular query?

do you need the mysqli library to use the new features of mysql5 from php; do u need php5?

Sorry again, but couldn't help posting it -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

tarantula · #5 07-26-2006, 02:16 PM

How do you actually use mysql5 stored procedures from php?

Answer
PHP Code:
$res = mysqli_query('call someprocedure()');

Ya, the performance increases with a stored procedure and in some cases. for example, a stored procedure can return multiple result sets but you need mysqli to access them and you don't need php5, just the mysqli extension. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --