i am running maxdb 7.50 Build005 on debian 3.0r2 with kernel 2.4.23-xfs.
i created a table
CREATE TABLE "ACCOUNTING"."CISCO3640BR_200310"
(
"ID" Integer NOT NULL DEFAULT SERIAL (1),
"SOURCE" Varchar (16) ASCII NOT NULL DEFAULT ' ',
"DESTINATION" Varchar (16) ASCII NOT NULL DEFAULT ' ',
"PACKETS" Integer,
"BYTES" Integer,
"TIMSTAMP" Timestamp NOT NULL
)i disabled the log and did not add an primary key and no index.
afterwards i inserted the data from a csv file (about 24mio rows)
the insert took on the test mashine 2hours (it has an slow megatrend raid5 controller :)
afterwards - still with disabled log - i tried to add an primary key over the ID field.
ALTER TABLE "ACCOUNTING"."CISCO3640BR_200310" ADD PRIMARY KEY ("ID")
now the sqlstudio is hanging since 5day's. and the machine is doing nearly nothing.
it does not respond to taskmgr and doesnt accept any commands, but it redraws from time to time the screen.
any ideas? is this possible to reindex 24mio rows?
and maxdb eats up more space on harddisk, as mysql does.
the table need's currently with maxdb 2.4gb space in harddisk (without primary key and without any index.)
mysql need's for the data 1.2gb and for index 631mb
is it normal, that maxdb need 3time's more space?
greetings thomas
-- -- # Thomas Stegbauer # http://www.keyserver.de:11371/pks/lookup?op=get&search=0xFF837A1A # Key fingerprint = E469 F5DC 42FB B530 F5CB 99CB CEB2 BFC6 FF83 7A1A
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
