Improving speed of large update

Thread View: borland.public.kylix.database.sqlservers

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Peter Laskey Fri, 30 Aug 2002 20:17

#113

Author: Peter Laskey
Date: Fri, 30 Aug 2002 20:17

9 lines
1763 bytes

I am writing a database application using Kylix 2 that builds a large dataset in memory based on the contents of a text file.  The dimentions are about 2800 X 14.  The time required to write the data to new records in the MySQL database is about 45 seconds.  Loading the same file into the MySQL database using it's own console-mode environment takes about two seconds.

There must be a way to improve the performance of Kylix's ApplyUpdates method.  I understand that it issues one query for each field of each record updated, or about 39 thousand seperate queries!  I know this behavior can be customized, but I don't know the best way to go about it.  Since reading the same amount of data from teh database takes about 0.10 seconds, there must be a way to update faster.

Does anyone have any ideas?

Thank you,
Peter
Flex Products, Inc.

Re: Improving speed of large update

#114

Author: Smith
Date: Thu, 05 Sep 2002 13:30

11 lines
1193 bytes

[...]

> Does anyone have any ideas?

To get higher power, I am implementing this www.openmosix.org :-)

Everyserver on my LAN share their "Bogomips" :-)

[...]

Erwan

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads