Subject | Re: [firebird-support] Slow database |
---|---|
Author | Milan Babuskov |
Post date | 2003-09-30T15:47:44Z |
Riho-Rene Ellermaa wrote:
Have you tried to separate script to smaller pieces to see what is slow:
connection? creating tables? inserts?
Also, maybe hard disks, P4 can work really slow if HDD is slow. You can
perhaps try to turn worced writes off, and see if there is any difference...
--
Milan Babuskov
http://fbexport.sourceforge.net
> I'm creating new database with IBO scripts. I use FB 1.03, Win2000, file extension is FDB.Anti virus software?
> Connection TCP_IP, localhost.
> First I create database and then run script that creates tables and fills them with data.
> Tables are quite simple (4-5 fields, with integer primary index). Total inserted rows is 1800.
>
> In my computer the script runs in 30 sec. In customers site computer it's 4 min. Log shows that database filling takes approx 3 min.
> I let him change from TCP_IP to local connection, but that didn't help. He has P4 computer that should be fast enough.
>
> Any ideas?
Have you tried to separate script to smaller pieces to see what is slow:
connection? creating tables? inserts?
Also, maybe hard disks, P4 can work really slow if HDD is slow. You can
perhaps try to turn worced writes off, and see if there is any difference...
--
Milan Babuskov
http://fbexport.sourceforge.net