> I would like to learn the primary key value of successful SQL
> Insert command.
see "Returning". I think it was introduced with 2.1 or 2.5, definitely
not with 1.5.x
Suppose you don't include an ID in the statement, but only "other
fields" and have the ID created by a Trigger.
Insert in
>I would like to learn the primary key value of successful SQL Insert command.
>The following syntax was
>picked up from (I think) a reliable source, cannot recall where. It generates
>an error at 'Output'.
>Could you please show me the correct syntax.
>
>'Insert into table( column set ) Values
>
> > One thing is not clear to me however. ALTER DATABASE shouldn't be IO
> > intensive,
>
> ALTER DATABASE is just a trigger to invoke nbackup.
>
>
What I meant is that ALTER DATABASE is only creates the delta file and not
starting to backup database pages.
> > also the server computers seem t
I would like to learn the primary key value of successful SQL Insert command.
The following syntax was picked up from (I think) a reliable source, cannot
recall where. It generates an error at 'Output'. Could you please show me the
correct syntax.
'Insert into table( column set ) Values(value s
> I am using SuperServer.
No, you are not!
If you are seeing FB_inet_server.exe in your Task Manager -- that is the
Classic server. SuperServer process name is FBServer.exe.
Sean
Hi.
I am using SuperServer.
Em 22/08/2013 17:56, Leyne, Sean escreveu:
>
> Hugo,
>
> > Is it a good idea setting DefaultDbCachePages to high value like "15000"
> > on a DB with page size 16k?
>
> No.
>
> With Classic you want to actually use a cache of 150-300 pages to
> reduce lock manager con
Hugo,
> Is it a good idea setting DefaultDbCachePages to high value like "15000"
> on a DB with page size 16k?
No.
With Classic you want to actually use a cache of 150-300 pages to reduce lock
manager contention.
> The speed of my queries increases.
This is due to the huge page cache setting
Hi Firends.
Is it a good idea setting DefaultDbCachePages to high value like "15000"
on a DB with page size 16k?
This causes de fb_inet_server.exe to consume around 240 megabytes of RAM
per connection. 50 connection 12 gigabytes.
The speed of my queries increases.
My question is about securit
> Your suggestion to change to Classic engine is one thing I really consider.
> It needs to be planned carefully in our case because the system is operated
> without real competent supervision and our operating mechanisms - that
> were serving us well in the past 10 years, starting from IB 6.0 -
Sean,
Thank You for the fast response, Your suggestions are greatly appreciated.
> We have FB 2.5.2 SS running on Win2003/x32 and Win2008/x64 servers.
> > around 50 - 150 user connects to de databases .
>
> I would recommend that you move to Classic engine, your system will
> perform better with
Subha,
> Greetings,
> I would like to use Firebird 2.5.2 in a IPV6 network. Can Firebird
> 2.5.2
> supports this feature?
Currently, IPv6 is not supported by any Firebird release.
There is a plan to add support in v3.0, which has recently released Alpha 1,
but that functionality is no
Subha,
> -Original Message-
> From: firebird-support@yahoogroups.com [mailto:firebird-
> supp...@yahoogroups.com] On Behalf Of subhadeep_samanta
> Sent: Thursday, August 22, 2013 2:50 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: IPv6
>
>
> I do have the sam
Zsolt,
> We have FB 2.5.2 SS running on Win2003/x32 and Win2008/x64 servers.
> around 50 - 150 user connects to de databases .
I would recommend that you move to Classic engine, your system will perform
better with that number of users.
> Every now and then some of our clients' FB server servic
My bad,
FB 2.5.1 SS, we are about to update.
sorry for the confusion.
Best Regards
Zsolt
--- In firebird-support@yahoogroups.com, Zsazsi wrote:
>
> Hi everyone!
>
> We have FB 2.5.2 SS running on Win2003/x32 and Win2008/x64 servers. around
> 50 - 150 user connects to de databases .
> Every n
Hi everyone!
We have FB 2.5.2 SS running on Win2003/x32 and Win2008/x64 servers. around
50 - 150 user connects to de databases .
Every now and then some of our clients' FB server service freezes at the
time we issue an ALTER DATABASE BEGIN BACKUP or start an nbackup session.
After the freeze the F
Greetings,
I would like to use Firebird 2.5.2 in a IPV6 network. Can Firebird
2.5.2 supports this feature?
For Connectivity we need Jaybird 2.2.3 and Dotnet drivers. Does they support
too ?
IF it is not supported. Do you have any plan for this support
Thanks,
Subha
I do have the same questions. adding my additional part here ..
For Connectivity we need Jaybird 2.2.3 and Dotnet drivers. Does they support
too ?
Can any one please help us on this ??
Thanks
subhadeep
--- In firebird-support@yahoogroups.com, "mariuz" wrote:
>
>
>
> --- In firebird-support@
17 matches
Mail list logo
