I've just set up a server with SAPDB and I am doing a test with the new instance that I had created. The server it's a PIII 1.7GHZ, 200MB RAM and 40GB. It has 2 hard disks. SAPDB is installed on the second disk. I am using Windows 2000 Professional.
This is the situation: I have two tables, and I need to do an insert on another table, so my statement is something like this: insert into tableC (select C1,C2...... from tableA, tableB where tableA.ID=tableB.ID); the select statement gives me 400,000 rows of data, and SAPDB takes 4 hours !!! to do this statement (I mean the entire insert statement). I had created an INDEX on tableA with the ID Column but it seems that it doesn't help too much. Also when I did the insert statement but with a GROUP BY, and a SUM function, SAPDB takes many hours to do it... I think it's an I/O problem, but I don't know how SAPDB solves these kind of problems. Actually I don't have any RAID or DISK ARRAY configuration, and I won't have it.... so how can I improve the performance of SAPD thanks, Alex _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
