Do both database have the same page size? Differences in page size could
also cause difference in performance.

BTW: Why don't you use a backup and restore to get an identical copy?

Mark

Guettler, Marco (Allianz Deutschland) wrote:

> Hello,
>
> I use 2 firebird databases with the same content in my tables and the same indexes.
> The first database is the original one, doesn't have any performance problem.
> My own, the second database has a bad performance (containing the same data and indexes),
> about factor 10 slower.
> I have to create a new, identical database because of different reasons (a clone by copy and paste is not possible).
> The procedure of creating the second database:
>
> 1. open der Security-DB (using standard user sysdba and password):
> ...\Firebird\bin>gsec.exe -user sysdba -password masterkey -database localhost:C:\Programme\Firebird\security2.fdb
> 2. adding new user
> GSEC> add myuser -pw mypw -fname C:\test\db\Firebird\xps.fdb
> 3. create new database using example database
> ...\Firebird\bin>isql localhost:C:\Programme\Firebird\examples\empbuild\employee.fdb -u myuser -p mypassword
> SQL> create database 'localhost:C:\test\db\Firebird\xps.fdb';
> 4. export scheme and indexes from the original database
> 5. import scheme and indexes into my new database
> 6. copy all data from tables (not system-tables) of the original database into the new database
>
> Maybe the problem is caused by the content of system tables I did not copy into the new database?
> But I really don't know which system tables are relevant and which data is necessary?
>
> Additional informations
> version: WI-V2.1.1.17910 Firebird 2.1
> model: classic as application (later embedded usage)
> language: java
> os: Windows XP Professional (32bit) version 2002, SP2
>
>
> It would give me great pleasure if somebody can help me. Thank you very much!
> Best wishes, Marco

--
Mark Rotteveel