How can I optimize SELECT .. FROM t1, t2 WHERE t1 join t2 ORDER by timestamp DESC LIMIT 10

I have a table which constantly grows. In selects I need only the (chronologically) last inserted x rows. The solution ORDER by timestamp DESC LIMIT x is a poor solution, since it is an O(n) case for the DBMS. Is there an elegant (probably mysql-proprietary) SQL-solution for this ? My solution

Re: Alteon + forks

-Ursprngliche Nachricht- Von: Pedro [EMAIL PROTECTED] An: [EMAIL PROTECTED] [EMAIL PROTECTED] Datum: 19 March, 2001 17:29 Betreff: Alteon + forks Hi, I have 2 servers and 1 alteon in HA. But the problem is that the alteon , when trying, to see if the servers are up or down , makes

Re: join from two different databases

-Ursprngliche Nachricht- Von: c.smart [EMAIL PROTECTED] An: [EMAIL PROTECTED] [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Datum: 18 March, 2001 01:11 Betreff: Re: join from two different databases Sorry, No Green Beer, No can do that ;-) Richard Reina wrote: I am try to

Re: Innobase in MySQL

-Ursprngliche Nachricht- Von: Heikki Tuuri [EMAIL PROTECTED] An: [EMAIL PROTECTED] [EMAIL PROTECTED] Datum: 17 March, 2001 17:35 Betreff: Re: Innobase in MySQL Andy, thank you for your benchmark :). I was also going to measure these, but have not had time yet. But what parameters you

Re: Re[2]: Innobase in MySQL

-Ursprngliche Nachricht- Von: Peter Zaitsev [EMAIL PROTECTED] An: Andreas Vierengel [EMAIL PROTECTED] Cc: Greg Cope [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Datum: 18 March, 2001 10:35 Betreff: Re[2]: Innobase in MySQL Could you tell me

Re: Access Ports

Try option --skip-grant-tables to mysqld or in mysql.cnf. This will dectivate ALL authorization-checking, but will make the server a little bit faster... --Andy -Ursprngliche Nachricht- Von: Van [EMAIL PROTECTED] An: [EMAIL PROTECTED] [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL

Re: Access Ports

-Ursprngliche Nachricht- Von: Van [EMAIL PROTECTED] An: Andreas Vierengel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Datum: 30 January, 2001 16:30 Betreff: Re: Access Ports Andreas Vierengel wrote: Try option --skip-grant-tables