Thanks for the response. We are running Windows. I'm not sure how much
information about the fb_inet_server processes I can gather -- other than how
long they've been running. Not sure how to get the IP address of the
connecting client. I'm going to just start killing the oldest
Thomas
We would be connected from Delphi and all our clients are on 2.1. But before I
get this implemented in code I would like to see it in SQL.
I have tried in both IBQuery and isql but whenever I run the following:
select * from MON$ATTACHMENT;
I always get an error that the table is
Write it as
select * from MON$ATTACHMENTS;
You were missing the last S
Alex
- Original Message -
From: grip_2ls li...@2ls.com
To: firebird-support@yahoogroups.com
Date: Thu, 20 Oct 2011 07:54:42 -
Subject: [firebird-support] Re: Find out how a user has connected to the
database
Hi
Thanks all for the information.
The database is ODS 10.1 so I guess that is the problem.
Thanks you all for your help. I will upgrade the db.
Neil
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
Hello Neil,
We would be connected from Delphi and all our
At 09:31 PM 20/10/2011, grip_2ls wrote:
Hi
Thanks all for the information.
The database is ODS 10.1 so I guess that is the problem.
Thanks you all for your help. I will upgrade the db.
...after CAREFULLY studying the v.2.1 release notes and migration/compatibility
guide, natch. ;-) You have a
Thanks Helen, I have just been looking at your Firebird 2 Supplement to work
out just exactly how I do it!
Neil
--- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote:
At 09:31 PM 20/10/2011, grip_2ls wrote:
Hi
Thanks all for the information.
The database is ODS 10.1
Hi,
Thanks everyone for replying. Here a quick update on the testing.
Put in a laptop to replace the server and the problem is gone.
Took the client's server back for testing and unsurprisingly the problem could
not be reproduced anymore at my office. Going to perform few test on the server
On Thu, 20 Oct 2011 11:18:23 -, gwc8182 gwc8...@yahoo.com wrote:
Hi,
Thanks everyone for replying. Here a quick update on the testing.
Put in a laptop to replace the server and the problem is gone.
Took the client's server back for testing and unsurprisingly the problem
could not be
John,
On 20/10/11 12:18, gwc8182 wrote:
Took the client's server back for testing and unsurprisingly the problem
could not be reproduced anymore at my office.
Ok, there's a clue there. The network at the customer site. Well, the
infrastructure at the customer site.
Going to perform few
Pepek,
The normal cause of wild variations in the performance of queries is
garbage
collection...
Garbage collection doesn't seem to play any significant part. I even
deleted the whole backup table, performed the backup/restore cycle, and
still got long times. What *did* help was
--- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote:
What is the analogous way to achieve this in Firebird (2.5) ?
INSERT INTO emp (fruits) values ('mango')
where not exists (select 1 from emp where fruits = 'mango')
Thanks for the quick reply.
Strange... when I try
I'm using a firebird embedded 2.5.0.26074 database via latest ado provider
which contains a simple table
CREATE TABLE INVENTORY (
ID ID NOT NULL /* ID = VARCHAR(36) NOT NULL */,
EXPIRYTIME EXPIRYTIME NOT NULL /* EXPIRYTIME = BIGINT NOT NULL */,
ITEMSIZE
Hello to everyone,
First off:
1. Used Firebird Version Model:
Firebird-2.5.1 - Embedded (x86)
2. Operating System
Windows 7 Enterprise x64
Windows 7 Professional x64
Windows 7 Enterprise x86
Windows 7 Professional x86
3. Language
C# + .NET-Provider FirebirdSql.Data.FirebirdClient (Version
I do not believe that that way be able to
You should make a stored procedure with:
SELECT 1 FROM T1 WHERE name = :imput_parameter
if (row_count = 0) then
INSERT INTO T1 (type, name, sysid, flag) values (1, :imput_parameter, 1, 0);
Best Regards
=
|| ISMAEL ||
=
- Original
On Thu, 20 Oct 2011 11:32:13 -, dasdiohsauiguihsfda
thomas.bue...@googlemail.com wrote:
3. Language
C# + .NET-Provider FirebirdSql.Data.FirebirdClient (Version 2.6.0, I
couldn't get 2.6.5 to work)
My Problem:
I am building a database which heavily relies on XML-Data. The problem
is
On Thu, 20 Oct 2011 11:04:33 -, canacourse canacou...@gmail.com
wrote:
I'm using a firebird embedded 2.5.0.26074 database via latest ado
provider
which contains a simple table
CREATE TABLE INVENTORY (
ID ID NOT NULL /* ID = VARCHAR(36) NOT NULL */,
EXPIRYTIME
Hi,
We have faced a very strange problem. We are running a firebird 2.5 database
with the following table structure.
CREATE TABLE TEST (
IDINTEGER NOT NULL,
MEMO BLOB SUB_TYPE 1 SEGMENT SIZE 80,
DATO TIMESTAMP
);
ALTER TABLE TEST ADD CONSTRAINT PK_TEST PRIMARY KEY (ID);
We
At 05:28 AM 21/10/2011, you wrote:
--- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote:
What is the analogous way to achieve this in Firebird (2.5) ?
INSERT INTO emp (fruits) values ('mango')
where not exists (select 1 from emp where fruits = 'mango')
Strange... when I
--- In firebird-support@yahoogroups.com, Helen helebor@... wrote:
Would you like to try this:
merge into t1 tab2
using t1 tab1
on tab1.name = tab2.name and tab1.name = 'Z'
when not matched then
insert (type, name, sysid, flag) values (1, 'Z', 1, 0)
That works like a charm!
Hi Ed,
merge
into emp
using (select 'mango' fruits from rdb$database) src
on emp.fruits = src.fruits
when not matched then insert (fruits) values ('mango')
Nice trick! That seems to work.
Just realized you can make it even easier:
merge
into emp
using
OK, then we'll need to look for less common problems. When the query
is slow, are you seeing lots of page faults? Process size growth?
What is the rate of reads/writes/marks/fetches? Do you have any guess
as to where the time is going?
Hi Ann,
I am afraid most of the values you are asking me
21 matches
Mail list logo