Hi,
Is there something I can do to find out which user is locking a particular
record in a database? If I can use the transaction number to lookup the
user, then I may be able to simply ask that user to re-start his machine?
The server is running Firebird Superserver 2.1.4 on Windows.
I am tryin
Il 06/02/2012 18.17, pluto.pippo66 ha scritto:
> Hi all
>
> I have aproblem with select fuction
>
> this is my function in C :
>
> the problem is 11 minuti for 160 select
>
> do you think is the right time ?
>
You should speed up things by executing all the selects in a single
transaction.
On 6-2-2012 18:17, pluto.pippo66 wrote:
> the problem is 11 minuti for 160 select
>
> do you think is the right time ?
What do you mean? Executing 1.6 million selects takes 11 minutes, or one
select producing 1.6 million rows takes 11 minutes?
If the first case, I don't think it is that wei
Hi all
I have aproblem with select fuction
this is my function in C :
int ReadValDbase(ISC_STATUS_ARRAY status,char* namedb,char* selstr,char* value)
{
charempdb[128];
char__Ex_value[128];
SQL_VARCHAR(20) fi
Hello, nathanelrick!
Monday, February 6, 2012, 5:38:42 PM, you wrote:
n> by kill mean
n> NET STOP "Firebird Server - DefaultInstance"
If this is Classic, you will just stop "listener" process,
and it will not stop sweeping. Maybe you have some fb_inet_server process
that "locks" sweeping.
If t
Svein Erling Tysvær wrote:
>
> you can miss some records from the last second (let's say 02-01-2012
> 23:59:59.1234).
How "exact" is a Firebird timestamp at all, and could I use fractions
of a second in a query? For example
where MyTimeStamp between '02-01-2012 00:00:00.' and '03-01-2012
23:5
by kill mean
NET STOP "Firebird Server - DefaultInstance"
this is not safe too do to this during a sweep ?
--- In firebird-support@yahoogroups.com, Alexey Kovyazin wrote:
>
> Hello,
>
> No, this is not normal.
> No, it's not safe to kill fb_inet_server (though I think you'll have no
> choice)
Hello,
I have a project that I'm doing, and it must have some sort of message
queue when data is added/changed.
I do not require heavy SQL work, but working with data both as a daemon and
on the web.
The daemon use the information that the web provides. But instead of
constantly checking for addi
Hello,
No, this is not normal.
No, it's not safe to kill fb_inet_server (though I think you'll have no
choice) - especially in old Firebird versions.
I would say you can have database corruption.
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
>
> Hello,
>
> Is it normal that the gfix -sweep
Hello,
Is it normal that the gfix -sweep run for more than 7 days ? our database is
pretty big (+300 Go) but 7 days it is not too much ?
Also, during this sweep, is it "safe" to kill the gfix or better to shunt down
the Firebird service of the fb_inet_server.exe ?
--- In firebird-support@yahoogroups.com, "Sergio H. Gonzalez"
wrote:
>
> Hello! I have a timestamp field with an index
>
> how can I select the fields from a given date, but using the index?
>
> If I do:
>
> where
> ((cast (MyTimeStamp as date)) between :from_date and :to_date)
>
> I gues
>> I'm trying with (to get all records from Feb 2nd)
>>
>> where
>> (MyTimeStamp between '02-01-2012 00:00:00' and '02-01-2012
>> 23:59:59')
>>
>> it uses the index, but I don't get all the records
>
>My mistake!... that seems to work OK... Now I just wonder if that is the
> *best* way to do
> For this test I'm using FlameRobin, but I have now also tried using the
> applicaton. I have tried with an alias and with a direct local path:
> D:\Passfield System\UAT Data\WHOLESALE_UAT.FDB
The database filter in the tag evaluates to a regular
expression filter using the new 2.5 SIMILAR TO
I've now tried removing the specific database and so just have
...
For this test I'm using FlameRobin, but I have now also tried using the
applicaton. I have tried with an alias and with a direct local path:
D:\Passfield System\UAT Data\WHOLESALE_UAT.FDB
> Just noticed, the database name is wholesale_uk.fdb
Make sure that you are using the correct database filter in the
tag then.
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
16 matches
Mail list logo