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 is

Re: join from two different databases

-Ursprüngliche 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: > >>

Re: Alteon + forks

-Ursprüngliche 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 ,

Re: Re[2]: Innobase in MySQL

-Ursprüngliche 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]

Re: Innobase in MySQL

-Ursprüngliche 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 paramete

Re: Innobase in MySQL

I've benchmarked a few scenarios to load mysqldumped data into an innobase-table (about 27 columns, mostly int's and float's) with about 150.000 rows with primary key and an additional unique key. The mysqldumped data was generated one insert per row (not dumped with --extended-inserts). 1. cat t

Re: Access Ports

-Ursprüngliche 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 wro

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 -Ursprüngliche Nachricht- Von: Van <[EMAIL PROTECTED]> An: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL