Slow select with 2 correlated subqueries.

Hi list, I am using MaxDB 7.5.0.18 on Windows currently and ran into the problem when my query running for minutes to return result set of 30 rows. First query (not as slow) looks like: select T1.DOWN_ID, T2.AN_ID from RELATIONSHIP_N T1, ENTITY_N T2 where T1.UP_ID = 1 and T2.AN_ID in ( select

Re: How do I get x rows after ordering and grouping?

José Rómulo Elías Contreras wrote: How do I get x number of rows in a select statement after ordering and grouping? I have the next select statement: SELECT * FROM SALES ORDER BY CREATION_DATE This statement give me many rows, but I only need de first 20 rows, or only I n

Re: no nntp accsess

bodo.t wrote: seems that the nntp access for mysql newsgroups news://lists.mysql.com/ does not realy work. at least is just get the subjects but not the body using Mozillas Thunderbird as the newsreader. You can get nntp access to this list also through the gmane service at nntp://news.gmane.org/

no nntp accsess

hello, seems that the nntp access for mysql newsgroups news://lists.mysql.com/ does not realy work. at least is just get the subjects but not the body using Mozillas Thunderbird as the newsreader. bodo -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscrib

RE: Question about DB-Analyser Messages

>I´ve found two messages in my dbanalyser log which I dont´t understand: > >> * W2 UKT7 is running since 901 seconds, actual run queue length is 0 This is a result from a known bug: http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1131604 >> * W3 15 isolated index range accesses, s

Are there any perfomance issues associated with using a single sequence for large transaction volumes?

Hello list, We are currently developing a large e-commerce site using SAPDB 7.4.3.27. We do expect to see a large number of inserts into the database, and are therefore considering how to assign key values for the inserted rows. Using a sequence is what we presently consider doing, as it has serve

RE: strange problem with rowno : doesn't produce good result set when where conditions are present

Hello Alexander, ok... then, the numbering (rowno) is done berore ordering... numbering in a last pass of the query (after ordering) would have be good idea ? > -Message d'origine- > De : Schroeder, Alexander [mailto:[EMAIL PROTECTED] > Envoyé : lundi 21 mars 2005 14:57 > À : Fabrice Bo

RE: strange problem with rowno : doesn't produce good result set when where conditions are present

> -Message d'origine- > De : Grossmann, Gert [mailto:[EMAIL PROTECTED] > Envoyé : vendredi 18 mars 2005 07:31 > À : maxdb > Objet : AW: strange problem with rowno : doesn't produce good result set > when where conditions are present > > > ROWNO hasn't same meanings as TOP in other DBS. >

RE: strange problem with rowno : doesn't produce good result set when where conditions are present

Hello Fabrice, Your first query sorts *all* matching rows, and then you look at the first 20 rows. Your second query selects some 20 rows (in no really predictable order), and sorts them. This is really not the same operation. Regards Alexander Schröder SAP DB, SAP Labs Berlin > -Origi

RE: strange problem with rowno : doesn't produce good result set when where conditions are present

ok, as you say, "then these x rows will be handled according ORDER BY clause..." then maxdb : - extract data (from clause) - order ligns - add the rowno column But i my case, the first 20 ligns from this query : SELECT ROWNO AS LNG, IMDO.IMDO_ID, IMDO.IMDO_CA FROMSA.IMPORT_D

RE: How to tune for better performance?

man, 21,.03.2005 kl. 11.00 +0100, skrev Koetter, Thomas Theodor: > > The test-machine is a P4 3GHz machine with 1G RAM and a 320GB ATA disk > > running Debian GNU/Linux "testing" and Linux kernel 2.6.8 with support > > for hyperthreading. The database has 4 x 500 GB raw devices + 1 60 GB > > raw d

AW: AW: statement too big for the log device

> -Ursprüngliche Nachricht- > Von: Martin Lackner [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 18. März 2005 16:24 > An: Brunzema, Martin > Cc: maxdb > Betreff: Re: AW: statement too big for the log device > > > Hello Martin, > > thanks a lot for your answer! > > >>I had a backup,

RE: How to tune for better performance?

Hi Jarle > -Original Message- > From: Jarle Aase [mailto:[EMAIL PROTECTED] > Sent: Montag, 21. März 2005 04:54 > To: maxdb@lists.mysql.com > Subject: How to tune for better performance? > > > Hi list, > > I've looked at maxdb, and it looks pretty sexy ;) I am however not > getting the p

RE: How to tune for better performance?

Jarle Aase wrote: > Hi list, > > I've looked at maxdb, and it looks pretty sexy ;) I am however not > getting the performance I expected. > > I'm researching different database-engines for a project involving a > database with several large tables. Some of the tables will contain > billions of r