Hello Ralf, is the
SELECT
COUNT("ID") AS REQUESTCOUNT,
"SESSIONID" AS SESSIONID,
MIN("PSESSIONID") AS PSESSIONID,
MIN("CREATIONDATE") AS CREATIONDATE,
MIN("IPADDRESS") AS IPADDRESS
FROM "MAIN"."REQUEST"
(I assume you missed a GROUP BY SESSIONID in the writing)
faster in producing output or comes it to a grinding halt
too? What is the result of an
EXPLAIN
COUNT("ID") AS REQUESTCOUNT,
"SESSIONID" AS SESSIONID,
MIN("PSESSIONID") AS PSESSIONID,
MIN("CREATIONDATE") AS CREATIONDATE,
MIN("IPADDRESS") AS IPADDRESS
FROM "MAIN"."REQUEST"
GROUP BY SESSIONID
Regards
Alexander Schröder
SAP DB, SAP Labs Berlin
-----Original Message-----
From: Ralf Udo Weisser [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 27. April 2006 18:03
To: [email protected]
Subject: Performance-Problem with 6 million rows and CPU load with 5%
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. In this table it has to be written nearly 5 million
rows, too.
In this Process the performance of the database is very slow, although
different index are set on this colums, where a maximum/minimum is
calculated. This calculation takes more than 6 hours. During this
aggragation I looked at the peformance of the system and I noticed, that the
system is not working to full capacity. The kernel-process of the database
was only at 5%.
My system has Windows XP Prof and 2 processors with 1 GB ram. I allocated
the database 500MB ram for the kernel-process.
Now my question is: Are there special parameters for the database, which has
to be set, so that it increases more performance and more processor load?
I can't invisage, that the problem arise from failure index or the
statement. As a precaution here is the statement:
INSERT INTO "MAIN"."T_VISITS"
SELECT
COUNT("ID") AS REQUESTCOUNT,
"SESSIONID" AS SESSIONID,
MIN("PSESSIONID") AS PSESSIONID,
MIN("CREATIONDATE") AS CREATIONDATE,
MIN("IPADDRESS") AS IPADDRESS
FROM "MAIN"."REQUEST"
with the Index to PSESSIONID, CREATIONDATE,IPADDRESS
Thank you very much.
Ralf Weisser
--
"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
