[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    AW: Performance problems ? witch parameter to change ?
From:       "Zabach, Elke" <elke.zabach () sap ! com>
Date:       2005-01-28 14:42:29
Message-ID: 235EE6AC8AE9264CBF763FC6749E2701017EC7B1 () dewdfe22 ! wdf ! sap ! corp
[Download RAW message or body]

Fabrice Bourdel wrote:
> 
> > -----Message d'origine-----
> > De : Schroeder, Alexander [mailto:alexander.schroeder@sap.com]
> > Envoyé : vendredi 28 janvier 2005 10:48
> > À : Fabrice Bourdel
> > Objet : RE: Performance problems ? witch parameter to change ?
> > 
> > 
> > Hello Fabrice,
> > 
> > please tell how you insert these lines (which interfaces, are
> > this single line inserts or batch inserts). Do you insert these
> > rows having some 'autocommit' property on?
> > 
> > Regards
> > Alexander Schröder
> > SAP DB, SAP Labs Berlin
> > 
> > > Also, i think i have also another problem when i am doing
> > > lots in insertions
> > > on maxdb : i need to insert monthly 25000 to 30000 ligns of
> > > data ; each line
> > > contains mostly text data, but not more then 10 fields. I
> > > take a very long
> > > time and the disk while inserting is accessed all the time,
> > > maybe a problem
> > > with caching ? i searched and saw that MaxDb is waiting for
> > > the log to be
> > > written to disk ; is the log_io_queue param the only param to
> > > shift ? the
> > > actual
> > > value is 50 pages ; for the example above, i tryed to shift
> > > le value to 100
> > > pages but the insertion is not quicker. Any suggestions ?
> 
> Another question too :
> 
> is is better to always specify the schema every where where is it possible
> ?
> is it quicker anyway ?
> 

It is a good idea to specify the owner / schema_name in front of the tablename in the \
from-clause of a select / behind DELETE / UPDATE and so on. This will 'speed up' a \
little bit during preparation of the command, not for execution (if this is done \
several times with the same prepared statement). But compared to the amount of time \
needed for the full select you will not be able to measure this. Adding the \
schema_name in front of every tablename.columnname-specification is not necessary.

Elke
SAP Labs Berlin 

> 
> Regard
> 
> 
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/maxdb?unsub=elke.zabach@sap.com


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com



[prev in list] [next in list] [prev in thread] [next in thread]