Very slow execution of a script that creates a lot of metadata [CORE2933] #3316
Comments
|
Commented by: @dyemanov Please attach your scripts here or (if they're not for public access) send them to me: firebird2 at yandex dot ru. |
|
Commented by: Edgard Candido de Oliveira Neto (econeto) Dmittry I just sent the scripts by your email. |
|
Commented by: Edgard Candido de Oliveira Neto (econeto) Follows attached files |
Modified by: Edgard Candido de Oliveira Neto (econeto)Attachment: core_2933_script.rar [ 11599 ] |
|
Commented by: Edgard Candido de Oliveira Neto (econeto) By analizing the results, I think the problem is at ALTER PROCEDURE statement. |
|
Commented by: @asfernandes Actually, the problem seems to be when engine tries to delete records from RDB$FIELDS. That happens when altering procedures with parameters. And it doesn't looks as a PLAN problems. Also, I see various ALTER TABLE being very slow, but reconnecting seems to make them faster again. |
|
Commented by: @dyemanov As far as I see, it is the optimization issue. And it's known to me, although I hoped to have it solved already. I will be trying to address this once more. |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Open [ 1 ] => In Progress [ 3 ] |
Modified by: @dyemanovstatus: In Progress [ 3 ] => Open [ 1 ] |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 RC3 [ 10381 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
Modified by: @dyemanovsummary: FB2.5RC2 - Very slow to execute script to create any metadata (database, tables storage procedures, ...) => Very slow execution of a script that creates a lot of metadata |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: Not enough information Test Details: Provided test contains script with unacceptable size (> 8Mb). Any idea about implementing something similar with the same effect will be appreciated. But I still can`t guess how estimate that time of creating database objects is good or bad (can`t connect at the same time to some other FB instance using fbtest). |
Submitted by: Edgard Candido de Oliveira Neto (econeto)
Relate to CORE3237
Attachments:
core_2933_script.rar
Votes: 3
When I execute scripts to create metadata (tables, sp, views,...) the server run very slow.
A script that runs at FB 2.0.5 (takes about 4minutes 24seconds) and runs at FB 2.1.3 (takes about 4minutes 51 seconds), at FB 2.5 RC2 takes more than ONE HOUR !
I tested many scripts files, and the results is the same.
If necessary, I can to send the files that I used.
My email is mailto:econeto@gmail.com
Thanks
Edgard de Oliveira
Rio de Janeiro - BRAZIL
Commits: 1f5e2c7 83f36de 6076393 c62a17c c6b776c 48d910f
====== Test Details ======
Provided test contains script with unacceptable size (> 8Mb). Any idea about implementing something similar with the same effect will be appreciated. But I still can`t guess how estimate that time of creating database objects is good or bad (can`t connect at the same time to some other FB instance using fbtest).
The text was updated successfully, but these errors were encountered: