Subject Re: [ib-support] %100 CPU usage with interbase, is it usual?
Author Claudio Valderrama C.
"KURSAT TASKIN" <kursatt@...> wrote in message
news:05664FAC761BD411B66D00D0B73EC3FE1DA598@ETIEXCHANGE...
> 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

I don't know how you do your operations, but make sure that you don't use
inefficient ways to insert data:
- Try an external file
- Failing that, PREPARE your insert statement and begin pumping the
information, then executing. Literal insertions like
insert into tbl values(1, 10, 'hello');
waste parsing time and CPU power. Instead, you prepare your insert
insert into tbl(f1, f2, f3) values(:v1, :v2, :v3);
and keep feeding this prepared statement with new values.

If your CPU keeps at 100%, at least make sure it's being used in something
productive.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing