I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardInterbase Topic   Print This     

problems with interbase-gbak-restore

problems with interbase-gbak-restore in Interbase topic (part of our DBA, Databases, & Data group).

Quick Search: problems   interbase   restore   problems interbase   problems interbase gbak  
nzayas
 (Inactive)
-- USA
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)
Comment Quote
About nzayas -Collapse +Expand
Visit Profile
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 
Joined=19 years ago   MB Posts=2  
Most Recent Post
nzayas
 (Inactive)
-- USA
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)
Comment Quote
About nzayas -Collapse +Expand
Visit Profile
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 
Joined=19 years ago   MB Posts=2  
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
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
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 
Joined=19 years ago   MB Posts=442   KB Posts=19  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P123A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #7608 Counter
3510
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech