Re: Why configuration directives are all case sensitive?

2012-11-23 Thread Tianyin Xu
Dear Eric, Thanks a lot for the explanation of argument directives! The concerns are very considerate. Actually, what I'm curious about is the configuration directives in the configuration file, i.e., my.cnf. To my experience, MySQL is the very few software who treats these directives in a case s

Re: Why configuration directives are all case sensitive?

2012-11-23 Thread Eric Bergen
Anger and OS religious arguments the real answer is that is just how the option parsing code works. It doesn't always have to make sense. There are short and long args to programs. For example on the mysql client there is --port or -P and --pasword or -p. The short options have to be case sensitive

Re: Stored Procedure Question?

2012-11-23 Thread Peter Brawley
when I call a stored procedure does the control get backs immediately to the php script? No, sprocs wil lvery likely slow you down. Probably best to split the job into several part-tasks (i) read rows into a work buffer, (ii) walk the work buffer and mark done rows, (iii) walk the done list a

Re: Basic SELECT help

2012-11-23 Thread divesh kamra
Hi Is there is performance issue from this query on more then 5-10 million data On Fri, Nov 23, 2012 at 11:17 AM, Mogens Melander wrote: > Ok, to make up for my bad joke, here's the answer > to the original question. > > DROP TABLE IF EXISTS `test`.`atest`; > CREATE TABLE `test`.`atest` ( >

Re: Stored Procedure Question?

2012-11-23 Thread hsv
2012/11/23 10:49 +0530, Girish Talluru I have a scenario where I have to screen a huge bunch of records for in db using certain rules. I have done in traditional php style record by record and it took 90 mins for 4000 records. I have 800k - 900k records in production which might possibly