Hello Elke,
thank you very much for your response. Some Questions about your answer:
Zabach, Elke wrote:
Michael J�rgens wrote:
Hi,
we have a application which should handle a large amount of inserts in a very short time. I�m relative new to sadb database management. Can anybody give me a hint what are the most relevant db parameters for handling a large number of inserts? We are using SAPDB 7.4.3 on a 4 cpu 2.8 GHz Xeon RH 8.0 Linux box.
regards,
Michael
You know about the tool LOADER for handling large amounts of inserts? http://dev.mysql.com/doc/maxdb/en/2d/c6c63522b8057ce10000009b38f889/frameset.htm
There the command DATALOAD / FASTLOAD are those relevant for you.
Yes, I know, but we get the data through a j2ee application. so it will be impossible to use it.
On the other hand one should check that the DATACACHE is large enough to hold the whole table (especially if inserts are in random primary key sequence). If one loads the whole table at once (no inserts to be added to an existing table) it may be better for performance to do the create index afterwards, if indexes are needed for this table.
You mean the parameter CACHE_SIZE - right? What about the parameters MAXSERVERTAKS and _IOPROCS_PER_DEV ?
regards,
Michael
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
