People, you also need to take into account that MYSQL is a pile of xxxx when dealing with complex queries. The problem there as i saw it can also be a db optimizer problem. I would recommend trying it on PostgreSQL. and doing "explain analyze" on this query. I have a feeling it would come out in secs even with the current settings.
Btw, i would also recommend checking out query rewriting features for queries like that. On Wednesday 21 March 2007 23:46, Geoffrey S. Mendelson wrote: > On Wed, Mar 21, 2007 at 11:09:21PM +0200, Shlomi Fish wrote: > > However, I disagree with Geoffrey on the fact that you need Oracle or DB2 > > or a different operating system than Linux (or BSD). By all means, Linux > > runs very well on this hardware, and PostgreSQL and MySQL are as fast as > > Oracle or DB2 or even more. > > I just want to make the point that I said "appropriate hardware and > operating systems". I did NOT say that Linux (or BSD) was not a good > choice. > > > With 30 million records in a database, I would seriously consider > a different hardware platform. Some of the perform quite well with > Linux some do not. > > > As for development being done on Linux systems (mostly PCs), for the > small demands of a development system compared to large database > servers, a PC is a good platform and a decent Linux distribution > (in terms of stability and maintainability) is fine. > > BTW, speed is rarely an issue in choosing a database system. Stability, > reliability and scalability are much more important. > > As you said, Oracle has a much richer set of SQL functions than any > of the others, that may be a bigger concern than price. > > > Geoff. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html ================================================================To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
