| Subject | RE: [ib-support] %100 CPU usage with interbase, is it usual? |
|---|---|
| Author | Wilson, Fred |
| Post date | 2001-12-28T15:49:12Z |
Is this a program that you wrote ?
If so, what are you using for database access ?
How many tables does the import data occupy ?
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@...
-----Original Message-----
From: KURSAT TASKIN [mailto:kursatt@...]
Sent: Friday, December 28, 2001 8:29 AM
To: 'ib-support@yahoogroups.com'
Subject: RE: [ib-support] %100 CPU usage with interbase, is it usual?
How are you importing data into the GDB?
When you import it using extrenal tables, IB will run this import in a
priority-thread and therefore using pretty much power as it can get.
Kursat: I am not using external table, I am inserting 1.000.000 record one
by one with a while loop
If you import data using other mechanisms, be sure to disable all indizes
you can to speed up import. Keeping the indizes active will require much
processing power for every insert and thus killing your machine. WIth
disabled indizes, import will be _much_ faster and the CPU will lock up only
for the time rebuilding the index, which should be not as long as the
importing itself.
Kursat: I do not have any index (if I understood the word "indizes" your
wrote, if it is another thing can you explain because I do not know)
I do not know another way to import data, also I can not do this with
external file because my fields do not have fixed with.
thanks alot
kursat
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
If so, what are you using for database access ?
How many tables does the import data occupy ?
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@...
-----Original Message-----
From: KURSAT TASKIN [mailto:kursatt@...]
Sent: Friday, December 28, 2001 8:29 AM
To: 'ib-support@yahoogroups.com'
Subject: RE: [ib-support] %100 CPU usage with interbase, is it usual?
How are you importing data into the GDB?
When you import it using extrenal tables, IB will run this import in a
priority-thread and therefore using pretty much power as it can get.
Kursat: I am not using external table, I am inserting 1.000.000 record one
by one with a while loop
If you import data using other mechanisms, be sure to disable all indizes
you can to speed up import. Keeping the indizes active will require much
processing power for every insert and thus killing your machine. WIth
disabled indizes, import will be _much_ faster and the CPU will lock up only
for the time rebuilding the index, which should be not as long as the
importing itself.
Kursat: I do not have any index (if I understood the word "indizes" your
wrote, if it is another thing can you explain because I do not know)
I do not know another way to import data, also I can not do this with
external file because my fields do not have fixed with.
thanks alot
kursat
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/