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