Speed differences between joins and subqueries?

Hi all, I am wondering if anyone have any knowledge if there is speed difference between joins (inner | outer | left | right) and subqueries. Would I actually gain preformance using subqueries (new since 4.1) against using the "old" joins? Would be interesting to hear comments on this matter,

Re: Large database with High Availability - how to do it?

Jonas Oreland wrote: Hi Daniel, Daniel Ek wrote: I really thought that MySQL tried to produce MySQL cluster for common hardware and with the design principle; more nodes with common hardware, insted of few nodes with extreme hardware. we do. I will probably never work for a company that can

Large database with High Availability - how to do it?

I really thought that MySQL tried to produce MySQL cluster for common hardware and with the design principle; more nodes with common hardware, insted of few nodes with extreme hardware. That to get higher availability (Much like the GFS (Google File System)). If the memory usage (RAM) as I have

Would MySQL 4.1 (Cluster) be a good solution?

Hi, My team and I have developed a nifty little app, which somewhat unfortunately, requires some time to process the data (15 million rows x 5 million rows x 3 million x 157 rows) when joining the queries. We have worked very hard and dedicated trying to optimize the queries as good as we can

Would MySQL 4.1 (Cluster) be a good solution?

Hi, My team and I have developed a nifty little app, which somewhat unfortunately, requires some time to process the data (15 million rows x 5 million rows x 3 million x 157 rows) when joining the queries. We have worked very hard and dedicated trying to optimize the queries as good as we can

SV: Querying serveral databases (Views?)

No I did not. Thank you very much! Regards Daniel -Ursprungligt meddelande- Från: Jeff Mathis [mailto:[EMAIL PROTECTED] Skickat: den 5 mars 2004 00:48 Till: Daniel Ek Kopia: [EMAIL PROTECTED] Ämne: Re: Querying serveral databases (Views?) in case someone hasn't answered you yet.

msSQL <-> MySQL (exhanging data between the two)

User -> CRM -> MsSQL (<)--> MySQL --> Apps that relies on MySQL data I would be thankful to any comments and/or suggestions I can get Regards Daniel Ek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Querying serveral databases (Views?)

ll be implemented, or other solutions to the problem? And with that I don't mean the "make more connections" fix, since I don't feel it's a neat way to solve it. Thanks in advance Regards Daniel Ek -- MySQL General Mailing List For list archives: http://lists.mysql.com