Issue Details (XML | Word | Printable)

Key: CORE-381
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: adnanoncevarlik
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Slow updates after first UPDATE

Created: 03/Jun/04 12:00 AM   Updated: 13/Nov/07 04:40 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

Issue Links:
Relate
 

SF_ID: 965580


 Description  « Hide
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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alice F. Bird added a comment - 14/Jun/06 09:38 AM
Date: 2005-01-07 12:59
Sender: adnanoncevarlik
Logged In: YES
user_id=1046258

Thank you.
I wish Firebird Developers will solve this problem in FB 2.0 :)

We are waiting.

Best regards

Alice F. Bird added a comment - 14/Jun/06 09:38 AM
Date: 2004-11-17 20:53
Sender: dimitr
Logged In: YES
user_id=61270

In fact, it's a design pitfall, but perhaps it could be
improved in the future.