You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I think there is an Update problem FireBird Server v1.5
on Windows.
I want to explain what I did.
1. Insert 500,000 Record to Table.
2. Add new fields to table.
3. Update values to new fields from old fields.
4. After Updates, Re-Run Update Query.
The 4. step is very slow process. The step 3 has been
done 50 sec. but step 4. has been done 12 Minutes.
(some times 8 minutes, some times 18 minutes.) Very
interesting.
Here is the structure and queries and other informatin.
Submitted by: adnanoncevarlik (adnanoncevarlik)
Relate to CORE1575
SFID: 965580#
Submitted By: adnanoncevarlik
Hi,
I think there is an Update problem FireBird Server v1.5
on Windows.
I want to explain what I did.
1. Insert 500,000 Record to Table.
2. Add new fields to table.
3. Update values to new fields from old fields.
4. After Updates, Re-Run Update Query.
The 4. step is very slow process. The step 3 has been
done 50 sec. but step 4. has been done 12 Minutes.
(some times 8 minutes, some times 18 minutes.) Very
interesting.
Here is the structure and queries and other informatin.
FB Version
Firebird-1.5.0.4306 (Win32)
OS Version
Windows 2000 Server (5.00.2195 SP 4)
Hardware
Inter Celeron 1.7
512 MB DDR RAM
Table Structure (Before The 2. Step)
CREATE TABLE TEST1
(
NAME VARCHAR( 20) COLLATE
PXW_TURK,
SURNAME VARCHAR( 20) COLLATE
PXW_TURK,
EMAIL VARCHAR( 50) COLLATE
PXW_TURK,
WEB VARCHAR( 50) COLLATE
PXW_TURK,
ADDRESS1 VARCHAR( 50) COLLATE
PXW_TURK,
ADDRESS2 VARCHAR( 50) COLLATE
PXW_TURK,
CITY VARCHAR( 20) COLLATE
PXW_TURK,
COUNTRY VARCHAR( 20) COLLATE
PXW_TURK,
DESCRIPTION BLOB SUB_TYPE 1
SEGMENT SIZE 80);
Table Structure (Before The 2. Step)
CREATE TABLE TEST1
(
NAME VARCHAR( 20) COLLATE
PXW_TURK,
SURNAME VARCHAR( 20) COLLATE
PXW_TURK,
EMAIL VARCHAR( 50) COLLATE
PXW_TURK,
WEB VARCHAR( 50) COLLATE
PXW_TURK,
ADDRESS1 VARCHAR( 50) COLLATE
PXW_TURK,
ADDRESS2 VARCHAR( 50) COLLATE
PXW_TURK,
CITY VARCHAR( 20) COLLATE
PXW_TURK,
COUNTRY VARCHAR( 20) COLLATE
PXW_TURK,
DESCRIPTION BLOB SUB_TYPE 1
SEGMENT SIZE 80,
NEWNAME VARCHAR( 15) COLLATE
PXW_TURK,
NEWSURNAME VARCHAR( 15) COLLATE
PXW_TURK,
UNITEDNAMES VARCHAR( 30) COLLATE
PXW_TURK);
Theres in no PrimaryKey, Index, Trigger other constraints
in the DB.
Update Query
UPDATE TEST1 SET NEWNAME=NAME,
NEWSURNAME=SURNAME, UNITEDNAMES = NAME ||
SURNAME
This query runs after first run is too slow.
Best Regards
Adnan ONCEVARLIK
Istanbul/TURKEY
The text was updated successfully, but these errors were encountered: