Just noticed, the database name is wholesale_uk.fdb
Make sure that you are using the correct database filter in the
database ... tag then.
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
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
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 database ... tag evaluates to a regular
expression filter using the new 2.5
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 that... So far
--- In firebird-support@yahoogroups.com, Sergio H. Gonzalez
shg_sistemas@... 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
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 ?
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,
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
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 ak@... 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, 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 this is
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
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
12 matches
Mail list logo