Joining on non unique index is irrationally slow, I can beat join performance with stored procedure 100 fold!!!!

2005-02-21 Thread Bereczki Gabor
nerators?" posting), if there are too many action statements, the stored procedures rapidly uses up all memory without doing anything. Thanks, -- Bereczki Gabor <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Are the stored procedures merely codegenerators?

2005-02-20 Thread Bereczki Gabor
it is covered by the many SP related bugs, but I am really curious how SPs are actually processed? -- Bereczki Gabor <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Non root user MySQL install possible?

2005-02-19 Thread Bereczki Gabor
=. --datadir=./data --err-log=./mysql.log -- pid-file=mysql.pid âsocket=./mysql.sock or if installed from source: ./bin/mysqld_safe --basedir=. --datadir=./data --pid-file=mysql.pid -- socket=./mysql.sock 7. Start mysql client mysql âsocket=./data/mysql.sock -- Bereczki Gabor -- MySQL General Mailing

Approximately when is a beta with useable stored procedures released?

2005-02-19 Thread Bereczki Gabor
about when a beta is available with useable stored procedures? If not what other options do I have for fast cursor processing? (I dont want to code in C.) Thanks, -- Bereczki Gabor <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub