Bill,
we have been running what in our understanding was a huge mixed
dBase/Delphi 7 application until 2006. DBFs until 2004, then switched
to Firebird for data, then replaced (nearly) all code by C#/.net.
When the performance of an application on a well equipped Classic
Server is
Hey Guys,
Sorry for the necro-post. I did complete the update to Firebird 2.5.2, and for
a month or so here, the issue did not occur again.
Unfortunately, it has since reoccured. FBSERVER.exe was only using 8mb of
memory when I connected to take a look.
I had a Firebird Tracing tool
On Sun, Mar 31, 2013 at 11:23 AM, wan30032 wan30...@yahoo.com wrote:
hello,now i used type is smallint.
but there are more than 4,000,000,000 records.
so i want to change with like ms sql tinyint.
I think what you want is :
CHAR[1] Character Set Octets
Don't use VARCHAR[1] - that
Hello, wan30032!
Sunday, March 31, 2013, 7:23:14 PM, you wrote:
w hello,now i used type is smallint.
w but there are more than 4,000,000,000 records.
w so i want to change with like ms sql tinyint.
I need to say some, against char(1) etc. instead of
smallint
- rows are being compressed in
On Wed, Apr 3, 2013 at 5:25 PM, Ann Harrison aharri...@ibphoenix.comwrote:
**
I think what you want is :
CHAR[1] Character Set Octets
Don't use VARCHAR[1] - that will make each one three bytes long. And be
careful of the layout of your records. For example, if you sandwich your
CHAR[1]
Hi,
We are using a set of 20 databases that are accessed simultaneously by 20 (or
more) applications (each one with multiple threads). These applications
(written in c# and using the FirebirdSql.Data.FirebirdClient.dll) basically
retrieve records from the database, perform a special processing
Sorry for the necro-post. I did complete the update to Firebird 2.5.2, and
for a month or so here, the issue did not occur again.
Unfortunately, it has since reoccured. FBSERVER.exe was only using 8mb of
memory when I connected to take a look.
You have to fine-tune memory usage. You also
We have a database that we want to wipe and replace every week,
regardless of whether it is in use.
Are these the correct steps? I notice that 'gfix -online' throws an
error, probably because the database is online after gbak completes. Is
there a way for the restore to not become online during
On Wed, Apr 3, 2013 at 12:25 PM, Markus Ostenried mac...@gmail.com wrote:
... be
careful of the layout of your records. For example, if you sandwich your
CHAR[1] between two integer columns, you'll get three bytes of padding so
the integers align on natural boundaries.
Out of
Hello, Rick!
Wednesday, April 3, 2013, 11:09:33 PM, you wrote:
RD gfix -shut single -force 1 server:/opt/firebird/db/clone.fdb
RD rm -fv /opt/firebird/db/clone.fdb
RD gbak -v -use_all_space -r /mnt/usb/firebird/clone.fbk
RD server:/opt/firebird/db/clone.fdb
RD gfix -online normal
ISC ERROR CODE:335544375
ISC ERROR MESSAGE:
unavailable database
After not working with database for some time,
I forgot the answer to the error above.
Anu help will be appriciated.
fdguard and fbserver iss running.
Regards
Freddy
11 matches
Mail list logo
