problems with interbase-gbak-restore

|
nzayas
|
I have a problema with a GDB. I execute a query into this gdb and the perfomance of this query is good, bat I make a backup and restore to my gdb and I try to execute the same query and now the time to execute this query is very long. The plan that ibserver uses to execute the query in both database is different. Why? Is there any problem with gbak restore GDB's?
|
Posted 19 years ago (Thread Starter)
|
|
About nzayas |
|
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #7608, 2 replies
Thread Started 9/19/2002 2:08:00 AM
View Counter=3510
Last Reply Posted 9/25/2002 12:50:00 AM)
|
|
|
Location=-- USA
|
|
 |
Most Recent Post
|
nzayas
|
Firstly, thank you for you repply. The setting deactive indexes was off when I made the restore and de size page was the same than the original GDB. I tried with a bigger size page but the result was worst.
|
Posted 19 years ago (Thread Starter)
|
|
About nzayas |
|
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #7660 (Level 1.1)
Reply to 7608
Thread Started 9/25/2002 12:50:00 AM
View Counter=2
|
|
|
Location=-- USA
|
|
 |
|
Scott Wehrly
Prestwood IT
(Inactive)
Las Vegas, NV USA
|
When you did the restore, did you somehow turn the "Deactivate indices" setting on?
It sounds like this might have happened, and that's why the execution plans are different. The main reason for slower execution plans in InterBase is lack of indexes.
Another question, did you set the page size to the same setting during the restore?
If so, then you have cut the transactional cache down, and this is going to eat into your execution time. Also, if you managed to raise the page size higher than the server can support (for instance, going from 4096 to 8192), you're actually crippling the InterBase server by doing so, because each transactional page still has to be broken into two packets to be returned to the client.
|
Posted 19 years ago
|
|
About Scott Wehrly |
|
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #7625 (Level 1.2)
Reply to 7608
Reply Posted 9/20/2002 6:36:00 AM
|
|
|
Location=Las Vegas, NV USA
|
|
Revive Thread!
Add a comment to revive this old thread and make this archived thread more useful.
Thread #7608 Counter |
3510 |
Since 4/2/2008
|
|
|
|