oracle & mysql
547350Nov 24 2006 — edited Nov 24 2006Hallo *
following situation: a modest amount of records (~50 000 000 per day) needs to be inserted in the table with couple of indexes .Tha data comes in files ~ 40 000
rows in each( at daytime every 1 or 2 minute).Currently this is done on small sunblade 100 with IDE harddisks with mysql :every 1/2 hour a new table is generated and untill number of rows less than ~ 3 000 000 the machine is able to keep up with the data.At night time the small tables are merged and indexed and compressed in 1 big table .The number of queries is very small(10-20-50 a day) and always uses indexes.Recently we decided to try to use Oracle for this task (sunfire 880 with 4 processors and T3 FC) and we were quite impressed that it seems not to be feasible.We have a partition for every day with 4 subpartitions, but anyway the system is not able to keep up with incoming data.Most time it waits for I/O.Indexes and table are created NOLOGGING.So the question :Is it posible to realize this on Oralce or Oracle just not suitable for such kind of application ?