Subject RE: [firebird-support] CS restore much, much faster than SS?
Author Helen Borrie
At 08:26 AM 1/06/2005 -0400, Bob Murdoch wrote:
>Pavel,
>
> > -----Original Message-----
> > From: Pavel Cisar [mailto:pcisar@...]
> > Sent: Tuesday, May 31, 2005 4:04 AM
> >
> > I suppose you have used local connection? Then no wonder it's
> > faster with Classic, because when local connection is used,
> > classic is loaded directly into address space of client
> > process, thus there is no overhead in data transfer between
> > address spaces of different processes. And restore means a
> > lot of data to transfer :-)
>
>What would the command line look like for a 'local connection'?

Pavel's comment isn't applicable to CS on Windows. (I checked backed to an
earlier message of yours, where you stated "I'm running FB 1.5 classic on a
Win2k3 server, with an 18GB database."

Bradley's observations were re SS vs Classic on Linux.

>I currently use gbak -c <backup file> <server:restore file>
>
>I tried changing <server:restore file> to just <restore file>, but
>gbak failed.

That's right, because gbak has to connect to the database when it has
created it; and local connections to Classic on Windows have to be through
localhost or (in some Windows configurations) the server's explicit node
address.

./hb