8 messages in com.mysql.lists.gui-toolsRe: The infamous 1104 too many record...| From | Sent On | Attachments |
|---|---|---|
| Tom Achtenberg | 22 Jul 2003 10:07 | |
| Adam Majer | 22 Jul 2003 23:02 | |
| Tom Achtenberg | 23 Jul 2003 07:07 | |
| Adam Majer | 23 Jul 2003 08:33 | |
| Tom Achtenberg | 23 Jul 2003 10:13 | |
| Adam Majer | 23 Jul 2003 11:13 | |
| Adam Majer | 24 Jul 2003 15:56 | |
| Adam Hooper | 24 Jul 2003 18:30 |  .diff |
| Subject: | Re: The infamous 1104 too many records error |
|---|---|
| From: | Adam Majer (ada...@galacticasoftware.com) |
| Date: | 07/23/2003 08:33:53 AM |
| List: | com.mysql.lists.gui-tools |
On Wed, Jul 23, 2003 at 07:07:26AM -0700, Tom Achtenberg wrote:
You are right, it does not happen with earlier versions, only in 0.9.2. We are
looking at accessing about 300,000 rows and summing them into 51 output rows.
Only 3 fields involved. It is a summary of donations in a calendar year by
state of origin. When I copied the tables from MySQL to my local SQL server
2000 the query ran in 6 seconds. It will not run in the MySQL CC 0.9.2.
There are many things wrong with 0.9.2 -- I cannot use it since it doesn't copy & paste properly. ie. it ignores the format that you specify and uses its own.
Anyway, do you mean that you never actually read the 300k rows just ask MySQL to work on it, right?
- Adam
-----Original Message----- From: Adam Majer [mailto:ada...@galacticasoftware.com] Sent: Tuesday, July 22, 2003 11:03 PM To: Tom Achtenberg Cc: 'mysq...@lists.mysql.com' Subject: Re: The infamous 1104 too many records error
On Tue, Jul 22, 2003 at 10:08:08AM -0700, Tom Achtenberg wrote:
I know 2 months ago Jorge answered with a solution to the 1104 too many records
query error. Several others have re-asked the question and been referred to his
solution. I have implemented Jorge's solution and still get the error. Has
anyone come up with another solution to the 1104 error?
Hmm, never got this even with 80,000 rows (took some time to display though :). It was some previous version though.
How many fields and rows are we talking about here?
- Adam