Subject | RE: [ib-support] %100 CPU usage with interbase, is it usual? |
---|---|
Author | KURSAT TASKIN |
Post date | 2001-12-28T15:53:13Z |
Is this a program that you wrote ?
If so, what are you using for database access ?
How many tables does the import data occupy ?
Kursat: I have only one table, 3 field, and 1.000.000 record txt file, I
read data from txt file with a while loop using IBODatabase, IBOQuery,
IB_Script, first delete all the record, and then read the data one by one.
insert into GDB and then post. thats all. PIII 650 my computer is, 192 RAM,
WinNT
This should be a problem at all. We have a spec that requires 1,000,000,000
records in, 1,000,000,000 records out, and 1,000,000,000 records "processed"
per day on out system, still allowing other client applications to work
during all this. We do it with no problems at all. We have a very, very high
speed system. Our "real time" client applications do 10 database accesses
per second, and we can support, on the base hardware platform, 25 "real
time" clients, and still have non-real time clients running, including the
data "loader" and the data "unloader".
Tell us more about how you are trying to do this, what hardware platform and
software platform that you're using.
Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@...
If so, what are you using for database access ?
How many tables does the import data occupy ?
Kursat: I have only one table, 3 field, and 1.000.000 record txt file, I
read data from txt file with a while loop using IBODatabase, IBOQuery,
IB_Script, first delete all the record, and then read the data one by one.
insert into GDB and then post. thats all. PIII 650 my computer is, 192 RAM,
WinNT
This should be a problem at all. We have a spec that requires 1,000,000,000
records in, 1,000,000,000 records out, and 1,000,000,000 records "processed"
per day on out system, still allowing other client applications to work
during all this. We do it with no problems at all. We have a very, very high
speed system. Our "real time" client applications do 10 database accesses
per second, and we can support, on the base hardware platform, 25 "real
time" clients, and still have non-real time clients running, including the
data "loader" and the data "unloader".
Tell us more about how you are trying to do this, what hardware platform and
software platform that you're using.
Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@...