Subject | Slow database |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2003-09-30T05:31:53Z |
I'm creating new database with IBO scripts. I use FB 1.03, Win2000, file extension is FDB.
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?
Riho-Rene Ellermaa
senior programmer
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?
Riho-Rene Ellermaa
senior programmer