RE: How to speed things up in MySQL ?

2003-01-26 Thread Markus Gieppner
, January 25, 2003 5:15 PM Subject: Re: How to speed things up in MySQL ? Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with the data? Thanks, Bhavin. - Original Message - From: Thomas Kvamme [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25

RE: How to speed things up in MySQL ?

2003-01-26 Thread Loren McDonald
Just to toss something into the fray: I had a similar problem, where any query was taking a very long time to run. I never did discover what the problem was but suddenly, one day later the problem was gone. I had rebooted my server twice in the mean time with no resolve. There is quite a bit

Re: How to speed things up in MySQL ?

2003-01-26 Thread Benjamin Pflugmann
Hi. On Sun 2003-01-26 at 00:26:32 +0100, [EMAIL PROTECTED] wrote: Here is the table definition as requested. I'm sorry I could take a full dump... Each record consist of approx 600 KB (just as in the Paradox table) so the file would be very big. (200 MB). Well, you should have told us that

Re: How to speed things up in MySQL ?

2003-01-26 Thread Thomas Kvamme
Zak Greant wrote: I am coming in a bit late on this - however, did you send in a copy of the table structure? It sounds like you don't have indexes on the tables. --zak On Sun, Jan 26, 2003 at 12:59:31AM +0100, Thomas Kvamme wrote: Hi again, Just did another test which I find very

Re: How to speed things up in MySQL ?

2003-01-26 Thread Thomas Kvamme
Benjamin Pflugmann [EMAIL PROTECTED] wrote: Hi. Hi Benjamin :-) On Sun 2003-01-26 at 00:26:32 +0100, [EMAIL PROTECTED] wrote: Here is the table definition as requested. I'm sorry I could take a full dump... Each record consist of approx 600 KB (just as in the Paradox table) so the

Re: How to speed things up in MySQL ?

2003-01-26 Thread Benjamin Pflugmann
Hi. On Sun 2003-01-26 at 15:22:06 +0100, [EMAIL PROTECTED] wrote: Benjamin Pflugmann [EMAIL PROTECTED] wrote: [...] Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have selected ID ProductionYear in the SELECT statement ?? Because you have a table with variable-width

Re: How to speed things up in MySQL ?

2003-01-26 Thread Sergei Golubchik
Hi! I guess the reason for this is that the I have a some blob fields whitch are all used.. (each record consist of approx 600 KB...) Yes, it's the reason. 600K per record... But since I donesn't include any of the blob fields in the SELECT statement I can't see no reason why MySQL should

Fw: How to speed things up in MySQL ?

2003-01-26 Thread Rubens Jr.
[...] Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have selected ID ProductionYear in the SELECT statement ?? Because you have a table with variable-width records and there is no way to easily find out where a field of a record is stored without reading all.

Re: How to speed things up in MySQL ?

2003-01-26 Thread Thomas Kvamme
Sergei Golubchik [EMAIL PROTECTED] wrote: Because MyISAM always reads the record as a whole, it cannot read only selected fields. You can convert your table to InnoDB table type - as InnoDB *can* read only selected fields. Actually, it's useful optimization to store big, rarely selected

Re: How to speed things up in MySQL ?

2003-01-26 Thread Steven Roussey
I guess the reason for this is that the I have a some blob fields whitch are all used.. (each record consist of approx 600 KB...) There it is. MySQL's MyISAM will get the whole record even if it only needs a part. You can try InnoDB as it does it differently. [At some point I may try and add

Re: How to speed things up in MySQL ?

2003-01-26 Thread Thomas Kvamme
Steven Roussey wrote: I guess the reason for this is that the I have a some blob fields whitch are all used.. (each record consist of approx 600 KB...) There it is. MySQL's MyISAM will get the whole record even if it only needs a part. You can try InnoDB as it does it differently. Hi

How to speed things up in MySQL ?

2003-01-25 Thread Thomas Kvamme
Hello, While reading this you may think this is off-topic... but please read on.. I'll get on-topic in the end :-)) First of all I have Web Server on which I have a Paradox table with 320 records. I also have a CGI Script (or program if you like) I made in Borland Delphi which I use to access

Re: How to speed things up in MySQL ?

2003-01-25 Thread Bhavin Vyas
Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with the data? Thanks, Bhavin. - Original Message - From: Thomas Kvamme [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 7:36 AM Subject: How to speed things up in MySQL ? Hello, While

Re: How to speed things up in MySQL ?

2003-01-25 Thread Benjamin Pflugmann
Hi. On Sat 2003-01-25 at 13:36:01 +0100, [EMAIL PROTECTED] wrote: [...] mysql select count(id) as Films, ProductionYear from DVD - group by ProductionYear - order by ProductionYear desc; [...] 39 rows in set (13.32 sec) mysql *** How is this

Re: How to speed things up in MySQL ?

2003-01-25 Thread Thomas Kvamme
Subject: Re: How to speed things up in MySQL ? Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with the data? Thanks, Bhavin. - Original Message - From: Thomas Kvamme [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 7:36 AM Subject: How

Re: How to speed things up in MySQL ?

2003-01-25 Thread Thomas Kvamme
BY on the same table in MySQL takes 13 seconds... still can't belive it. -- Thomas - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Thomas Kvamme [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 5:15 PM Subject: Re: How to speed things up in MySQL

Re: How to speed things up in MySQL ?

2003-01-25 Thread Frederick L. Steinkopf
AM Subject: How to speed things up in MySQL ? Hello, While reading this you may think this is off-topic... but please read on.. I'll get on-topic in the end :-)) First of all I have Web Server on which I have a Paradox table with 320 records. I also have a CGI Script (or program if you