thanks Serge..
incidentally my very first post to the list contained my query , and is the reason I joined this list in the first place. This 3 year sales report has been running for over 24 hours now. this is unacceptable, since they also wanbt a 5 year one and I am sure that will take 5 years to run... at this rate. -----Original Message----- From: Serge Paquin [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 11:01 AM To: Mark Matthews Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL vs. Oracle (not speed) I think this is a touch on the negative side. I'm sure many people get soured on MySQL when they to a post here and get yelled at for not trying hard enough. It sounds like Mary is having a valid problem. Her query works fast in one database and slow in the other. Because she did not come out and put her table schema and sql in the first email is no reason to insult her. I think a helping hand is a better approach. Mabey a couple general suggestions on MySQL tuning and a "We would need to see the schema and SQL statement to help further". I agree that it seems very strange that MS-SQL runs fater than MySQL on a query. Microsoft seems to always be plaiged with performance problems. Insulting someone will not help convert them to MySQL it will drive people away. Anyway enough of my rant... Serge. On Fri, 16 Aug 2002 09:46:44 -0500 "Mark Matthews" <[EMAIL PROTECTED]> wrote: > Mary Stickney wrote: > > What exactly is Trolling.... > > > > > > I find MYSQL to be slow , sorry if that doesn't met with your approval. > > But you don't give examples. > > I've found MS-SQL to be slow at times, especially when used from JDBC, > but I don't make crack comments about it newsgroups without backing up > my claims. > > Why don't you show us your queries? Do you really care to learn if MySQL > could be faster and you're just using it wrong? > > -Mark > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
