Performance TD 5.2

forum.td.development (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

Performance TD 5.2

Post by NewsgroupServer » 30 Jun 2010, 15:36

 Posted by:  Pablo Foti 

I've a app that makes a composition of balances.

Speed of process

with TD 4.1 -> 18 min
with TD 5.2 -> more than 1 hr 30 min

To generate the final result set, the application performs inserts and
updates in auxiliary tables. Finally query the auxiliary tables.
There are 4 auxiliary tables.
The last query returns around of 190.000 registries.

I've a function with a main query and while it returns a new row, it goes
making differents inserts, updates and queries of auxiliars tables. The SQL
statements are prepared before the main query (with SqlPrepare) and it are
executed (SqlExecute) while the query returns each row.

attached a generic example.

thanks in advance

Pablo

Attachment: TD52_example.txt

Return to “td.development”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests