Hi.
in firebird 2.5
Simple descriptables
table_ud
ud_id integernotnullprimarykey
field_udvarchar(6)
rowcount: 383322
table_tmp
ud_id integer
cndinteger
index (cnd)
rowcount: 617
UPDATEtable_udud
SETud.field_ud = '201401'
WHEREud.ud_id in (SELECT t.ud_id FROMtable_tmp t where t.cnd =
look for CHR(13)+CHR(10) at the end of lines
open external table with editor (I use textpad) is good for big data.
good luck
Germán
El Jueves, 11 de septiembre, 2014 20:14:24, 'Edward Mendez'
emendez...@nc.rr.com [firebird-support] firebird-support@yahoogroups.com
escribió:
Hi All,
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.
- Look memory at each step
Good luck
Germán
El Viernes, 12 de septiembre, 2014 15:37:38, Alexey Kovyazin a...@ib-aid.com
[firebird-support]
Hi.
in firebird 2.5
Simple descrip tables
table_ud
ud_id integer not null primary key
field_ud varchar(6)
row count: 383322
table_tmp
ud_id integer
cnd integer
index (cnd)
row count: 617
UPDATE table_ud ud
SET ud.field_ud = '201401'
WHERE ud.ud_id in (SELECT t.ud_id FROM table_tmp t
Hi.
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.
Solutions?
Thanks.
It is a good idea to backup and restore the database to recreate them with the
new OSD.
This will improve performance and MAYBE this can solve your problem.
De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Enviada em: quarta-feira, 29 de outubro de 2014 11:05
Create a backup with Firebird 1.5, restore it with 2.5.
Make sure to keep a copy.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From:
When moving old firebird versions (2.0 and earlier iirc) from 32 bit to 64 bit,
you need to backup (with 1.5) and restore (with 2.5). Make sure you use the -
default - transportable backup
Note in general it is advisable to backup and restore when migrating between
versions as this upgrades the
in fb 1.5 fix and backup database
in fb 2.5 restore database with fix malformed unicode_fss data and metadata
atencion to date and datetime data en fb 1.5
good luck
El Miércoles, 29 de octubre, 2014 11:13:01, 'm...@lawinegevaar.nl'
m...@lawinegevaar.nl [firebird-support]
Yes. in fb 1.5 is very disastrous
Thank
El Miércoles, 29 de octubre, 2014 10:39:34, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]
firebird-support@yahoogroups.com escribió:
Hi.
in firebird 2.5
Simple descrip tables
table_ud
ud_id integer not null
Hello All,
I have few tables which are used for many years as temporary table,
but that time was not possible to create them in Firebird.
Do you know any hack over system tables which would allow to change
normal table to global temporary and it will not cause some problems?
It would be
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 instructed - I
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
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
Cron calls a simple bash script with the following command for each of the
databases :
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,
I want to replace my Firebird 32 1.5.6 with the last Firebird 64 2.5.3,
http://www.slideshare.net/ibsurgeon/firebird-migration-from-firebird-15-to-firebird-25
Regards,
Alexey Kovyazin
IBSurgeon
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 installation
Thanks. I`ve fixed the config and started a new trace session. Now we wait
again :)
2014-10-29 21:31 GMT+02:00 Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] firebird-support@yahoogroups.com:
Trace config :
database orbis-aton
enabled true
print_perf true
log_sweep
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
t...@camalot.ca [firebird-support] wrote:
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.
[...]
Also, we had always run Firebird as Superserver.
[...]
At 12:59 p.m. 30/10/2014, Geoff Worboys ge...@telesiscomputing.com.au
[firebird-support] wrote:
Is it safe to assume that, when you were running SuperServer,
you had edited firebird.conf to change the installation default
CpuAffinityMask from 1 to 15 ? (So that it would use all 4 of
your
Helen Borrie hele...@iinet.net.au [firebird-support] wrote:
At 12:59 p.m. 30/10/2014, Geoff Worboys
ge...@telesiscomputing.com.au [firebird-support] wrote:
Is it safe to assume that, when you were running SuperServer,
you had edited firebird.conf to change the installation default
Helen Borrie hele...@iinet.net.au [firebird-support] wrote:
At 12:59 p.m. 30/10/2014, Geoff Worboys
ge...@telesiscomputing.com.au [firebird-support] wrote:
Is it safe to assume that, when you were running SuperServer,
you had edited firebird.conf to change the installation default
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 to the
same
27 matches
Mail list logo