> Normally a stored procedure is limited to "core 0" along with anything else > that can't be multithreaded. If you could do your task in a preemptive worker > or a SQL process you'd probably get better response time from your clients.
Don't forget that a stored procedure (a process started with the NEW PROCESS command) can also be preemptive if the method called by NEW PROCESS has the preemptive property checked. https://blog.4d.com/preemptive-processes-for-4d-language/ http://doc.4d.com/4Dv16/4D/16.3/Project-method-properties.300-3670767.en.html http://doc.4d.com/4Dv16/4D/16.3/Preemptive-4D-processes.300-3651705.en.html -Tim ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
