Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Interbase running on a VM



Permlink Replies: 1 - Last Post: Jul 6, 2017 8:48 AM Last Post By: quinn wildman
Jeff Cope

Posts: 88
Registered: 1/27/01
Interbase running on a VM
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 6, 2017 8:07 AM
IB XE3 - We are having some performance issues with a long-running process. This process seems to get exponentially slower when running on a VM. This same difference performance can be seen with a database restore.

Example of database restore tested on 3 different machines:

Server VM Mag Drive : 1 hour 10 minutes
Workstation Mag Drive: 46 minutes
Workstation SSD: 20 minutes

The server is quite a bit beefier in terms of available drive space, processor and available physical memory than either of the workstations. Yet it takes nearly 20 minutes longer than the workstation with a mag drive.

Is this expected performance behavior?

Are there settings best suited for a VM environment we should look at changing?
quinn wildman

Posts: 856
Registered: 12/2/99
Re: Interbase running on a VM
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 6, 2017 8:48 AM   in response to: Jeff Cope in response to: Jeff Cope
InterBase has no VM specific settings. You should debug the problem exactly the same as if it were on a non-VM machine.

I'll note that when I was with Embarcadero, QA did most of it's testing using VM's.

Jeff Cope wrote:
IB XE3 - We are having some performance issues with a long-running process. This process seems to get exponentially slower when running on a VM. This same difference performance can be seen with a database restore.

Example of database restore tested on 3 different machines:

Server VM Mag Drive : 1 hour 10 minutes
Workstation Mag Drive: 46 minutes
Workstation SSD: 20 minutes

The server is quite a bit beefier in terms of available drive space, processor and available physical memory than either of the workstations. Yet it takes nearly 20 minutes longer than the workstation with a mag drive.

Is this expected performance behavior?

Are there settings best suited for a VM environment we should look at changing?
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02