> > Is mySQL planning on fixing this BUG. YES -- it is a BUG. A > BIG FAT HARRY > > ONE. > > > > I think you mean 'hairy', not 'harry'. There are no 'harry' > bugs, apart
LOL! Doh! Yeah. I was so blinded by rage that I forgot my spelling. > > It's completely stupid that I can't query and get an > accurate total of > > records in a table in under a second. > > > > If it's so important to you, why not maintain your OWN count. > Cache the > figure somewhere, or update a figure when you insert a record. Because we're a huge enterprise product, with 3 databases of > 200 tables each. We are migrating from MYISM to INNODB and keeping track of that value isn't something we thought we'd need to do. Plus it seems like something we _shouldn't_ have to do. That's WHY we use a database. > > A deviation of 40-50% is SIGNIFICANT! > > You might as well just use RAND() at that point. > > Fine. Use rand() if it makes you happy. Sarcasm. Cool. :) > > This is absolutely baffling and astonishing how a company > so seemingly smart > > could make such an incredible blunder. :-\ > > > > Oh the melodrama! Won't someone please think of the children! ...and the homeless ...and Katrina victims ...and Tsunami in India victims ;-p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]