Performance-Problem with 6 million rows and CPU load with 5%

2006-04-27 Thread Ralf Udo Weisser
Hi, I am a beginner in MaxDB issues. My Problem is: I save data of requests from a server-system in one table. This table has nearly 6 million rows. Now I want to aggregate this data. In this task I make a INSERT in another table. This statement insertes the aggregated data from the request-table.

RE: Error in input parameters of replace function was cause database crash

2006-04-27 Thread Zabach, Elke
maxdb [mailto:[EMAIL PROTECTED] wrote: > Hi, > > I was mistake and take name filed parameter on arg #3 instead > of arg #1 in > replace database function. As result the next select was > cause database > crash. > > select id, replace('\"','', name ) from test > > > Table 'test' was have fie