AW: Performance problems ? witch parameter to change ?

Fabrice Bourdel wrote:
> 
> > -----Message d'origine-----
> > De : Schroeder, Alexander [mailto:alexander.schroeder@xxxxxxx]
> > 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@xxxxxxx


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx