PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → Slow updates of firebird database
Slow updates of firebird database
Started by Paul Turner, Sep., 12 2005 6:30 PM - No answer
Posted on September, 12 2005 - 6:30 PM
With mass inserts into a firebird updates I'm only getting about 20 inserts per second (with a small record size so network traffic isn't a problem.

My code is of the form:

while condition is true
sql_query.col1 = 123
sql_query.col2 = 456
hadd(sql_query)
end

Is there anything I can do within the code to speed this up?