Dear all, I experience slowdown in execution of following statement. It almost takes 11.5 sec to complete, total rows in table is 6677 is it expected execution speed or is there any workaround that I can increase the execution of speed?
Exeucuted Query: update elements E set E.END_I = (select n.node_num from nodes N '+ 'where abs(E.X_I -N.XI)<0.001 and abs(E.Y_I - N.YI)<0.001 and abs(E.Z_I-N.ZI)<0.001 ) The result of Flamerobin is as follow: Executing... Done. 78935476 fetches, 15862 marks, 411 reads, 1 writes. 0 inserts, 6677 updates, 0 deletes, 0 index, 14549183 seq. Delta memory: 19956 bytes. ELEMENTS: 6677 updates. 6677 rows affected directly. Total execution time: 11.848s Script execution finished. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
