suggestion for more efficient inner join algorithm

ard to any reactions Best regards, Tim Samshuijzen Software & database engineer mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

question on indexes

Hello, I have two tables: CREATE TABLE categories ( CategoryNumber int(11) NOT NULL, ItemNumber int(11) NOT NULL, KEY CategoryNumber (CategoryNumber), KEY ItemNumber (ItemNumber) ); CREATE TABLE items ( ItemNumber int(11) NOT NULL auto_increment, Description varchar(100) NOT

RE: amazingly slow

s over time they lose their performance enhancement. >could that be true? > >dan > > >-Original Message- >From: Tim Samshuijzen [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, 6 February 2001 04:50 >To: [EMAIL PROTECTED] >Subject: Re: amazingly slow > > > &g

Re: amazingly slow

set i believe the query should complete within short time. > >can you send the output of DESCRIBE db.tablename of all used tables? > >regards, > >rene > > > >- Original Message - >From: "Tim Samshuijzen" <[EMAIL PROTECTED]> >To: "René

Re: amazingly slow

0 308 2 297 380 34 16 50 1 0 0 3936 3072 10484 217860 0 0 0 0 10310 67 33 0 0 0 0 3936 4064 10500 218392 0 0 565 1 411 558 10 5 84 Does this make any sense to you? Tim At 12:17 PM 6-2-2001 +, you wrote: >Tim Samshuijzen &

Re: amazingly slow

;wordindex.word) ? I bet not. > > >----- Original Message - >From: "Tim Samshuijzen" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, February 06, 2001 12:04 PM >Subject: amazingly slow > > >> >> >> Hello, I don'

Re: amazingly slow

t (0.01 sec) This still does not tell me why the query is amazingly slow. Tim At 10:52 AM 6-2-2001 +, you wrote: >Tim Samshuijzen <[EMAIL PROTECTED]> writes: > >> Anyone out there who wants to save me and our company? > >You missed the i

amazingly slow

Hello, I don't understand why my queries are so incredibly slow. We have MySQL on a 800MHz Linux machine with 513Mb. Most queries look like this: SELECT B.* FROM maintable AS M, wordindex AS YL1, wordindex AS YL2, wordindex AS YL3 WHERE YL1.Word = 'billy' AND YL1.RecordNumber = M

Re: PHP does not work after upgrading MySQL to 3.23.32

w how dangerous this is, but it works! I will keep it this way untill someone here can recompile the libraries. Thanks! Tim Samshuijzen At 21:02 3-2-2001 -0500, you wrote: >The mysql version compiled into your web server uses shared libraries and >your current version (upgrade) apparently is a

Re: PHP does not work after upgrading MySQL to 3.23.32

Hey Rop, wist je wel dat ik het was (Tim van Rockingstone). wat toevallig dat je zat mee te kijken. (beetje laat of niet?) bedankt voor de tip. Tim Samshuijzen. (Sorry for the Dutch everyone) At 02:49 4-2-2001 +0100, you wrote: >On Sat, Feb 03, 2001 at 11:13:14PM -0200, Fábio Ottol

Re: PHP does not work after upgrading MySQL to 3.23.32

httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: >I suppose your operational system is Windows... Or is it Linux? Regarding >Windows at least, and I be

PHP does not work after upgrading MySQL to 3.23.32

Hi, I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does not work. I've tried restarting httpd, but an error appears "file not found", and httpd fails to start up. HELP! What am I doing wrong? Thanks,

upgrading to 3.23.32

Hello, I would like to upgrade MySQL from version 3.22.32 to 3.23.32. The upgrading needs to be done within seconds because the database is queried many times per second on a busy website. I am not an expert on compiling and installing software on Linux. Is it possible to simply replace the bin

Re: How to select the 10 last items from a table?

nt = 0; } then do the following: SELECT * FROM item ORDER BY id LIMIT $count,$limit; Tim Samshuijzen At 09:03 31-1-2001 -0600, you wrote: >Remco van den Berg wrote: >> >> On Wed, Jan 31, 2001 at 08:00:23AM -0600, The Tilghman wrote: >> > Try sorting in DESCending order

Re: idle CPU

the answers make sense thanks everybody! Tim Samshuijzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

idle CPU

Hello, We're running a large database on a dedicated server. When I look in the list of active processes, I notice that a complicated query takes up no more than about 30 % of CPU. During this time the CPU is more than 60 % idle. Is there some way to speed up the process? Tim Samshu

same file size after DELETE

Hello, I have just deleted thousands of records but the file is still the same size as before. How do I make the file compact? i.e. how do I get rid of all the "empty spaces" in the table? Tim Samshuijzen - Befo

MyFULLTEXT search

very big (more than 30 million records!). If it continues to grow like it does now, we will end up in problems in the near future. Could anyone give me advice on how to increase performance? Any help is much appreciated. Thanks! Tim Samshuijzen -

MyFULLTEXT search

very big (more than 30 million records!). If it continues to grow like it does now, we will end up in problems in the near future. Could anyone give me advice on how to increase performance? Any help is much appreciated. Thanks! Tim Samshuijzen -