Subject | RE: [ib-support] %100 CPU usage with interbase, is it usual? |
---|---|
Author | Kaputnik |
Post date | 2001-12-28T15:37:37Z |
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.
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.
CU,
Nick Josipovic
CRM Administration
BIT-Institute
Prof. Dr. Franz Steffens
Schloss
68163 Mannheim
Germany
Phone: ++49 621 181-1621
Fax: ++49 621 181-1618
mailto:nick.josipovic@...
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.
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.
CU,
Nick Josipovic
CRM Administration
BIT-Institute
Prof. Dr. Franz Steffens
Schloss
68163 Mannheim
Germany
Phone: ++49 621 181-1621
Fax: ++49 621 181-1618
mailto:nick.josipovic@...
> -----Original Message-----
> From: KURSAT TASKIN [mailto:kursatt@...]
> Sent: Friday, December 28, 2001 3:04 PM
> To: Ib-Support (E-mail)
> Subject: [ib-support] %100 CPU usage with interbase, is it usual?
>
>
> Hi,
> when I importing data into GDB the CPU usage rate becomes %100
> is it possible or I am making an error,
> if it usual how can I decrease the CPU usage. because I can not run any
> other application
> thanks
> 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/
>
>
>