RE: Performance problems ? witch parameter to change ?

> -----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 ?


Regard


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