At http://www.firebirdsql.org/en/downloads the available release of
Firebird to download is 2.5.2.
2.5.2 Update 1 is the latest official/production-ready release.
Somebody mentioned a 2.5.3 release. Is there a 2.5.3 release? I exist,
where can I download it?
Only as a snapshot build.
I would like to know if the TempCacheLimit parameter in SuperClassic is
like Classic or like SuperServer? So if it's per client connection or
it's for server process?
As in Classic, thus per connection.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and
On 25/07/2014 06:46, brucedickin...@wp.pl [firebird-support] wrote:
Hi,
1. I've deleted 50 records from TABLE A. I've commited transaction.
2. I made SELECT * FROM TABLE A. Transaction was starting for a very
long time.
I just wanted to make sure that there is no way to prevent this
Can FSQL http://mujweb.cz/iprenosil/interbase/fsql.htm connect to
embedded db on client machine where firebird is not installed.
Yes. You simply have to make sure that FSQL is loading the embedded
library and do not use a remote connect string, even not via 'localhost'
on the same
Hi,
in my db some tables have strange triggers: 'CHECK_X' ACTIVE POSITION 1
AFTER UPDATE or AFTER DELETE where the 'X' is a number. All these
triggers are empty (seeing them with flamerobin).
I tried to delete them but after this i have had to restore a backup
because the db was
Hi,
Hi guys,
I'm looking for some ideas how to find what is causing this lock.
I have 2 production databases that process multiple insert/update
statements. There is one background process that does all these
modifications 24h/day.
The problem is that with one of these databases almost
I recorded the process of backup , if anybody would be so kind to help
me, please take a look at :
FireBirdBackup http://youtu.be/txUruy35qHE
image http://youtu.be/txUruy35qHE
FireBirdBackup http://youtu.be/txUruy35qHE
This feature is not available right now. Please
I have one customer having this error message very often when he
starts software after he boots up his computer which is as server as
well
no permission for read-write accesstodatabase
C:\DATA\CUSTOMERS.FDB
He runs the software on Windows 8.1 Professional
I did some reconfiguration on a database yesterday, so I`m monitoring
the logs for any issues and I noticed something strange :
Mon Oct 27 16:54:25 2014
Sweep is started by SYSDBA
Database orbis-aton
OIT 21080, OAT 21081, OST 20456, Next 44177
(yes, I
I`m not sure if running a 24/7 trace is a good idea (database is under
relatively heavy load). Anything else I could do to help?
It might be ok with a proper include filter at service level from a
Trace API POV.
The following trace configuration should be fully dedicated to sweeping
only:
Well, I`ve done two things since the last post
1 I set the sweep interval to 10 (I assume I`m far from reaching
that on a normal day)
No change - Yesterday, another unexpected sweep at 5:08:03 pm
2 I started a trace session with the suggested config (changing only DB
alias, as
I want to replace my Firebird 32 1.5.6 with the last Firebird 64 2.5.3,
on 64b
All my databases was created with 32b, 1.5.6 Firebird.
After installed Firebird 64, if a try to connect to database.FDB a
received an error
database./fdb is not a valid database/.
Beside the other
Run stadistic for database
- Look for index in de big tables. Look for Depth 2. In this case
up Page size one step, and run database statistical.
2 is quite conservative these days with the available hardware
resources and even with a 16K page size you may reach that threshold
with indexes
Trace config :
database orbis-aton
enabled true
print_perf true
log_sweep true
exclude_filter %RDB$%
time_threshold 0
/database
services
enabled true
log_services true
include_filter Repair Database
/services
The database filter expects a regular expression and orbis-aton can't be
Hi Todd,
Thought I would share some experience we have gained recently.
We have an application consisting of a C++ Builder front end and
Firebird 2.5 as the backend. Running on Windows. The database includes
a ton of stored procedures with some fairly intricate calculations.
A typical
Hi Todd,
There are 46,527 records in the main table, but the calculation touches
many other tables. Here is a copy of the analysis of the main procedure
from IB Expert:
Query
Plan
Query
Hi Geoff,
Helen Borrie hele...@iinet.net.au [firebird-support] wrote:
At 02:36 p.m. 30/10/2014, Geoff Worboys
ge...@telesiscomputing.com.au [firebird-support] wrote:
Doesn't that depend on how they implemented the separate threads?
SS does/can use different threads for separate connections
Hello,
Hi!
I have some lines in firebird.log like this:
===
cxv.servers.netTue Nov 4 11:37:38 2014
Sweep is started by SWEEPER
Database SkyNetInt
OIT 1221095, OAT 1231335, OST 1231313, Next 139981575359934
cxv.servers.netTue Nov 4 11:37:46 2014
*UPDATE*
I have changed batch, switch -online before change write mode.
Actually the batch is:
%FB_PATH%\GSTAT.EXE -h %DB1% %LOG_FILE%
%FB_PATH%\GFIX.EXE -shut full -force 0 -user SYSDBA -password
masterkey %DB1% %LOG_FILE%
%FB_PATH%\GFIX.EXE -online normal -user SYSDBA -password
and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
Il Giovedì 13 Novembre 2014 17:48, Thomas Steinmaurer
t...@iblogmanager.com
[firebird-support] firebird-support@yahoogroups.com ha scritto:
*UPDATE*
I have changed batch, switch
Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3?
Usually this is not needed when the ODS version hasn't been changed
(between maintenance releases), but there is a special situation when
coming from 2.5.1:
Hello Christian,
I am having problems regarding an update skript I want to write that
fetsches data from table1 in db1 and writes the result into exisiting
records in table2 in db2.
To mange this task I am using firebird 2.1.5 and a tool called IBExpert
with a script extension called
Michael,
Does GBak behave different on a Classic Server than on a SuperServer regarding
restore speed?
I ask this, because around 1 year ago I installed Firebird 2.5 SS on a Windows
environment.
Here I did a restore of a 90 Gb DB.
This took around 8 hours.
Since then we have
Hello Michael,
* What is the page buffers value at database level? (gstat -h)
E:\DB\Kaufmannc:\Program Files\Firebird\Firebird_2_5\bin\gstat.exe
localhost:
e:\db\Kaufmann\OCCEasyPos.FDB -h
Database e:\db\Kaufmann\OCCEasyPos.FDB
Database header page information:
Flags
Isnt the transaction per second wrongly calculated?
Oops, sorry!!! I have been one year off by using 2014 instead of 2013.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning
Hello Michael,
Beside your gbak restore issue, your counters here show some interesting
throughput numbers, when taking the creation date of the database into
account:
~ 170 transactions / sec
~ 9 connections / sec
We have a external connection from a WEBStore.
Whatever they
Hello Michael,
I have a performance problem at a customer site.
At this point I suspect one specific external user connection to cause
the problems, but I can't pinpoint it so exactly just yet.
But there is one table, where there is inserted records almost all the
time.
When the user
Hi,
I am trying to migrate Firebird 1.5 dialect 1 charset NONE database to
Firebird
2.1 dialect 1 charset WIN1257 database, that still will be used by BDE.
All is working. The only problem is that metadata (code of procedures or
triggers) can not contain WIN1257 specific characters
Dave,
I'm just trying to clarify the status of multiprocessor/multicore
support in Firebird 2.5. I have found the architecture comparison page
which starts to explain this.
http://www.firebirdsql.org/manual/qsg25-appx-architectures.html
1. For Windows, we just need to update the
Thank you for the responses.
The application and stored procedures utilize a UDF.dll. Does this need
to change? Does it need to be compiled as a 64-bit .dll for the server,
but remain 32-bit on the clients?
The client application doesn't use the UDF library directly. The UDF
library must
The 64 bit installer also installs the 32 but library iirc. So there
should be no problem at all.
Yes, but people more and more use the ZIP distribution and AFAIK the
32-bit libraries aren't included in the 64-bit package, thus the
additional reminder ;-). At least not in 2.5.2. Haven't
Is is possible to use the 64-bit Firebird server with a 32-bit application?
Sure.
If so, is it recommended? What are the pitfalls?
The only one is that a 32-bit application needs to use the 32-bit
Firebird client library and not the one from a 64-bit Firebird server
installation
--
With
Hi
I have a system that is slowing down the longer it stays running and I'd
like to know why.
The system is running firebird 2.1.5 on centos 5 with an average of 27
transactions per second and has now been running for 112 days. The data
throughput is unchanged, data is removed from the
Hi,
I am trying such command:
gstat.exe 10.10.3.2:/Base/2534/2534.FDB -p password -u user -d
But I am getting an error that specified patch could not be find. I am
guessing
that I can not run gstat over a network?
Right. gstat is operating at physical file level and not through a
…many thanks; that’s what I was looking for! So there’s a great many work
under way, but it looks to me that v3 and v4 are currently more or less
optimizations / enhancements and no major changes coming up, right?
What are major changes from your perspective?
Fine-grained SMP with a shared
Hi SET,
I tried as below way by adding Group By clause:
with TMP(PK_JOB_ITEMS) as
(select distinct PK_JOB_ITEMS
from CRM_JOB_ITEMS where FK_JOB = '{8BDDED49-8509-48C1-A169-B7E68A74C230}')
select
Sum(cdi.QUANTITY) AS Delivered,
cdi.FK_JOB_ITEM
from tmp t
join CRM_DOCUMENT_ITEMS cdi on
great thanks
to make sure I've got this right
starting with the same database I can do either
a) gbak with gc
b) gbak without gc and gfix -sweep
and I will have the same final result
Extending this further, how can identify which tables contain (or did
contain) the garbage.
Number
Larry,
I am searching for a Macintosh OS X solution which supports .gdb
database files from the Hewlett Packard HP 200LX Palmtop.
I understand that Firebird can be installed on OS X, but need to know if
there might still be support for the .gdb files produced by the 200LX.
(I belong to an
---In firebird-support@yahoogroups.com, ts@... wrote :
Is this SuperServer only or also SuperClassic?
SuperServer only.
Thank you!
Thomas
Thank you !
Vlad
Vlad, does this issue affect classic and superclassic?
According to one of Vlad's previous message, only SuperServer.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database
Vlad,
---In firebird-support@yahoogroups.com, hvlad@... wrote :
Could you register it a tracker, please ?
Done: http://tracker.firebirdsql.org/browse/CORE-4830
Is this SuperServer only or also SuperClassic?
Thanks!
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
I think the image posting is not allowed here to display.
Below is the error message I see:
Note I have 2.75 GB free disk space.
*** IBPP::SQLException ***Context: Statement::FetchMessage: isc_dsql_fetch
failed
SQL Message : -901Unsuccessful execution caused by system error that does
.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
Thanks.
On Monday, 8 June 2015 12:51 PM, 'Thomas Steinmaurer'
t...@iblogmanager.com
[firebird-support
Niko,
'Parzival' parzival1...@gmx.at [firebird-support] schrieb am 02.06.2015 22:12:
Hello all,
for updating some tables at customers I create SQL scripts and execute them
with ISQL i parameter. This works perfect unless I have to insert german
special characters like äöüß.
The
Hello ,
So Dmitry suggested it , we have disabled IPV6 on our server CentOS 7
(Firebird
2.5.4 Classic server (I forgot to mention it in my first mail)).
By following the centos FAQ :
http://wiki.centos.org/FAQ/CentOS7#head-8984faf811faccca74c7bcdd74de7467f2fcd8ee
Rebooting the server.
Hello. I used Firebird 1.5.6 on server on WIN7, a database with a role with
full rights, and a user defined in ROLE, USER.
I have a problem. In the network with a application, on different client
station, login with the USER, all functions work OK.
From server or another WIN7 station,
srotyli...@gmail.com [firebird-support] schrieb am 23.06.2015 14:31:
Hi Karol, I think you are right on, I found this which is what I suspect is
throwing the error in 2.5 (but not so in 1.5). I might have to go back to my
old box running 1.5. Do you know if it is possible to convert and
/7145
Regards,
Thomas
Thanks,
Jack
C:\Firebird
On 6/11/2015 9:13 AM, 'Thomas Steinmaurer' t...@iblogmanager.com
[firebird-support] wrote:
The databases are backed up between midnight and 6 am when no one is
using them. However, the databases are still open in multiple
programs
variable etc.?
Regards,
Thomas
Jack
On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] wrote:
Hello,
We have backed up our databases daily for two years using Firebird 2.52
Superserver and its associated gbak. We now need to restore one of the
databases
/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com
[firebird-support] wrote:
The databases reside on a Linux Mint server, but we back them up to a
Windows 7 system. Both are running the same release of Firebird. We
use Linux as the server because Linux is far more reliable than
Hello,
We have backed up our databases daily for two years using Firebird 2.52
Superserver and its associated gbak. We now need to restore one of the
databases and gbak fails to do the restore, giving the following error:
[snip gbak output]
gbak: ERROR:action cancelled by trigger (3) to
I'm facing a problem where the firebird server v2.5.4 on win 2012 server in
superserver mode is leaking memory. Currently I'm at ~5GB usage.
Don't have any idea how to track down the problem.
Thanks for any advice.
When you open the Windows Task Manager, what's the name of the Firebird
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
Regards,
Karol Bieniaszewski
- Reply message -
Od: Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
firebird-support@yahoogroups.com
Do: firebird-support
---In firebird-support@yahoogroups.com, ts@... wrote :
From a throughput perspective, this would mean:
IB XE3 = 0,918 MB/s
IB XE7 = 1,896 MB/s
FB 3 = 3,282 MB/s
To be honest, astonishing low numbers in 2015, for all three.
To be even more honest, measure time of restore without
Thanks Steve for the information. I think we’ll try on a virtual machine
the centOS versions with the different mode of firebird (classic,
superserver, superclassic).
To Thomas, yes that’s real remote connections from different remote
servers (there is no local connections).
Ok, do they all
Hello,
we are still on FB 1.5 release, our live Database is about 50 GB. While
using the freshly restored database, things are very fast in the
beginning but they get slower and slower as weeks go by. We are always
forced to do a backup/restore after 4 weeks or so.
In the beginning we were
Hello Stefan,
Hallo all,
when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database
owner), the MON$ROLE field always shows 'NONE', even when the user is
logged in with a specific role.
Is there a way to find out the role another user (with a specifid
attachment_id) is logged
Hugo,
Hello.
1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD
NEW_COLUMN INTEGER NOT NULL). There were already some records in the
table. FB didn´t raise any warning or exception.
2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise
any warning or
Halim,
Thank you for your reply.
I just tested a GBAK restore using -se(rvice) switch on a 1 GB DB. It
took about 8 minutes. Restoring the same database using IBExpert took
about 3 minutes.
I'm looking for a faster restore time because I want to automate the
process using a batch file. Our
Hello all,
I came across something really strange as far as restoring a Firebird
database.
if I use IBExpert(a tool from HK Software) it takes about 3 hours but if I use
regular gbak using command line it takes 9 to 10 hours.
I'm using Firebird 1.5. IBExpert vesion 2008.08.08
I think I'm
Hello Walter,
Hello Thomas
That seems an interesting idea. Can you explain it with more details?
For the restore process, gbak supports a -BU(FFERS) switch to override
the database page buffer value. While page buffers tends to be rather
small for Classic/SuperClassic hosted databases, you
I have an 3rd party application running firebird 1.5.
I want to install firebird 2.5 instance, with my application, without
affecting
the other app.
I did a video on that topic quite some time ago.
Hi again,
Hi Eduardo,
[snip]
Firebird.conf:
-
DefaultDbCachePages = 1024
#FileSystemCacheThreshold = 65536 (commented out)
#FileSystemCacheSize = 0 (commented out)
Server environment:
--
CPU utilization: 11%
Memory utilization: 11
Hi Eduardo,
[snip]
Firebird.conf:
-
DefaultDbCachePages = 1024
#FileSystemCacheThreshold = 65536 (commented out)
#FileSystemCacheSize = 0 (commented out)
Server environment:
--
CPU utilization: 11%
Memory utilization: 11 GB (out of
> In response to your questions:
>
> What are the implications of holding a connection to the database open
> forever (and running millions and millions of tiny transactions flat out
> through that connection)?
>
> What difference would it make if we dropped the connection periodically?
>
> We had
> you should identity this long running transaction. if you use fb2.5 than
> this is simple by mon$TRANSACTIONS table
MON$ tables are even in Firebird 2.1.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager,
'Louis van Alphen' lo...@nucleo.co.za [firebird-support] schrieb am 14.10.2015
10:09:
> I think a tool like FBTraceManager from Thomas (Upscene) can do that for you
Unfortunately not. The Trace API does not provide that level of granularity for
PSQL code modules.
This has been a long
Kevin Meyers kevinjmey...@gmail.com [firebird-support] schrieb am 06.10.2015
22:36:
> I am wondering if any of you have every noticed any significant performance
> difference between using BIGINT versus INTEGER as an autoincremented
> primary key in Firebird. My idea is to use BIGINT and have
Niko,
> Hello all,
>
> i am running a simple query where the result contains 3 records. The
> query should provide all records in a specific week.
>
> SELECT * FROM ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND
> WOCHE = '2015-41';
>
> Some times I dont have a week but two dates:
>
> In
> Hello Team,
>
> A few days back, I posted a message regarding 'Firebird BLR 623 invalid
> request - LRTRIM is not defined -
> module name or entrypoint could not be found' when I ran some stored
> procedures that used either LTRIM
> or LRTRIM functions (occasionally,though not always).
>
>
Hello!
I have two databases in my Firebird 2.5.3
The first is of 7.5GB and second is of 2.0GB
My server has 4GB of Memory, and sometimes the service FB_INET_SERVER.EXE
starts eating my memory from 1.5GB to 2.5GB-3GB of memory and my system slows
down..
Same concurrent
Hi
We are moving to 64bit firebird 2.5 shortly and I'm looking at the
architectures
the first of these links seems to say that superserver is the only
option, the second say otherwise
can someone clarify please
http://www.firebirdsql.org/file/fb25_architecture_comparison.pdf
IMHO, this
Hello Group - Has anyone documented steps of how to create a Linked Server to
Firebird in MS SQL Server?
I'm running into issues and need help ASAP please. Much appreciated!
What issues?
I'm not sure if screen shots work, but here's the setup.
[cid:image003.jpg@01D0DF20.F6F9FBF0]
Hi,
At August 28, 2015, 10:59 AM, Nick Upson n...@telensa.com
mailto:n...@telensa.com[firebird-support] wrote:
On 28 August 2015 at 14:43, Thomas Steinmaurer t...@iblogmanager.com
mailto:t...@iblogmanager.com[firebird-support]
firebird-support@yahoogroups.com
> Hmmm,
>
>
>
> I tried again this evening and it would allow me to add the primary key. Very
> strange. Since we moved to a new windows server 2012 R2 and upgraded to
> v2.5.4
> firebird running Classic Super Server from v1.5.4 running Classic Server,
> could
> any of that have anything to
Hi,
> I had a look at IB LogManager. It doesn't quite do what I want.
>
> The requirement we have is to log only fields that change, not all
> fields (which is what IB LogManager does). If I change fields 1, 4, and
> 7 then those are the only fields I want logged (and not fields 1, 2, 3,
> 4, 5,
eck, Tuning etc.
> John
>
> ------------
> *From:* "Thomas Steinmaurer t...@iblogmanager.com [firebird-support]"
> <firebird-support@yahoogroups.com>
> *To:* firebird-support@yahoogroups.com
> *Sent:* Wednesday, September 23, 2015 11:36 AM
> *Subject:* Re: [f
Hello,
Executing the following in both, dialect 1 and 3:
select cast(current_timestamp as varchar(30))from rdb$database
results in a string with a different date/time format. At least on
Windows with Firebird 2.5 64-bit.
Dialect 1: 7-DEC-2015 20:29:12.3820
Dialect 3: 2015-12-07 20:31:07.2280
> On 8-12-2015 09:52, Thomas Steinmaurer t...@iblogmanager.com
> [firebird-support] wrote:
>> Hello,
>>
>> Executing the following in both, dialect 1 and 3:
>>
>> select cast(current_timestamp as varchar(30))from rdb$database
>>
>>
>> results i
>> I downloaded FB 2.5.5 from firebirdsql and my Microsoft Essentials
>> detected it as a malware.
>
> I am facing the same problem.
> The following file is affected:
> http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.5-Release/Firebird-2.5.5.26952_0_x64.exe/download
>
> This
> Hallo,
>
> Il 08/01/2016 16.22, Tim Ward t...@telensa.com [firebird-support] ha scritto:
>> What are your queries, query plans, query statistics?
>
> The queries are similar to: SELECT * FROM TABLE.
>
> Investigating for query plans, statistics, Buffers as suggested by
> Thomas, I discovered the
rgilland1...@gmail.com [firebird-support] schrieb am 27.11.2015 00:24:
> Hi,
>
>
> this is an output from ibexpert, no usage% column here either:
>
>
> Kind Regards,
>
>
> Robert.
>
>
> Database "OP.FDB"
> Database header page information:
> Flags 0
>
> Monday, November 30, 2015, 7:40:50 PM, Thomas Steinmaurer wrote:
>
>> That information is also available on the database header page,
>> which can be extracted by gstat -h
>
> Unfortunately, that information is absent from gstat -h, hence my
> advice to use isql SHOW DATABASE. I can't think why
rgilland1...@gmail.com [firebird-support] schrieb am 30.11.2015 05:10:
> Thanks Helen,
>
> I finally taught myself how to use isql.exe in order to access this
> information.
> What a strange tool.
>
>
> Then I found that both IBOConsole.exe and Upscene's Database Workbench show
> this
> Hi Robert, you can do this easily with a tool such as IBExpert. Just run
> Services / Database Statistics and this is the result:
>
> TableName SizeUsage%
> CUSTOMER 11,960,320 0.295
> PARAMFIL 16,384 1 0.000
>
Hello Fabian,
> Sorted after reading "Initializing the Security Database" from
> http://www.firebirdsql.org/file/documentation/release_notes/Firebird-3.0.0-ReleaseNotes.pdf
> at page 116. I think there is a small error on the documentation, where it
> says
> " isql -user sysdba employee", the
>> What value must it have? Add a default clause to this statement. Or add
> > the field as nullable, populate with data and then alter to NOT NULL.
>
> I have tried to add field as nullable, then tried to alter to not null.
>
> UPDATE TMP_RPT SET ID1 = '5'; Commit;
> (This statement is OK)
>
> 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit :
>> trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44:
>>
>>> Where I can download v3.0.1 ?
>>
>> 3.0.1 hasn't been released yet, but snapshot builds are available he
trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44:
> Where I can download v3.0.1 ?
3.0.1 hasn't been released yet, but snapshot builds are available here:
http://www.firebirdsql.org/en/snapshot-builds/
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional
> Thanks. For some Years, we have had in use the superserver, but since we
> have a quadcore CPU, we are using cs.
>
> UDFs can I replace with build in functions
I guess you can imagine that you first need to do that before backing up
and restoring?
> Now, I have restored the database with 2.5,
Hello Olaf,
> Hello,
>
> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to
> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit installation
> of Firebird too?
From an operational POV, a main factor with moving from 32-bit to
64-bit is if you are using (third-party)
Hello,
> Hallo,
> I have a small database (less 100MB) that works on Firebird 2.5.5
> SS64bit over a machine with Win7 64bit with 4GB Ram, CPU Pentium G620.
>
> I seems to work very well in local but with the 3 clients on LAN works
> very bad. It is very very slow to open and navigate a
> Yes, Thomas,
>
> it woks with 2.1. In the release notes of 2.5.X is written:
>
> Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw
> the error "value exceeds the range for valid timestamp".
>
> But where can I search 200 Tables...
Read Paul's blog on using -v for the
> now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1
>
> It works fine, but there is another problem to fix. Now I get the error,
> that value exceeds the range for valid timestamps. How can I fix this issue?
* When does that happen during the restore?
* Does a backup
> On 17-1-2016 00:07, Köditz, Martin martin.koed...@it-syn.de
> [firebird-support] wrote:
>> is there still a reason to use the Classic mode with Firebird 3? Since
>> there is real SMP support with SuperServer I don’t think there can be
>> advantages with ClassicServer.
>
> The main advantage of
> I have a state machine (workflow) implemented on a table a couple of
> million records and growing.
> I have crated an index on the "state" field. The possible states are
> very few (5 to 10). Obviously selectivity index is terrible. As I can
> optimize the query?
Hard to say without seeing an
Hi!
> Dear Friends.
>
> FirebirdSQL: 2.5.5 64bits
> Operating System: Windows 2008 R2 Enterprise 64bits
> Server: Dell Poweredge R620
> 32GB
> 2 processors E5-2609 2.40 GHz
>
> Hi.
>
> Is it possible to create an index like
>
> CREATE INDEX MYINDEX_IDX1
> ON MYTABLE (COLUMN1 ASCENDING, COLUMN2 DESCENDING )
No. You can't define ordering per index segment.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB
Hi!
> gbak:activating and creating deferred index K_MERCURY_EMAIL
>
> gbak:cannot commit index K_MERCURY_EMAIL
>
> gbak: ERROR:operating system directive CreateFile failed
Any chance that you are running out of disk where your TEMP directory is
located?
--
With regards,
Thomas
> There is 77GB free out of 148GB at the minute and it has restored 9GB so
> far, final size ~33GB so on the surface looks adequate unless very large
> temp files are created when the indexes are reactivated?
Yes. This may happen, depending on the index size. Are you sure that
temp space is
1 - 100 of 173 matches
Mail list logo