IS dal.update slower than db.update ?

Of course dal is efficient when it comes to script handling. But does dal necessarily deliver better performance when it comes to retrieving dal.get.error.message ? Will it slow down a process session trying to gather messages and write to report. Thanks.

Hi,

DAL may be the slower one as it has some additional checks before actually hitting the database. I guess DAL is handled by an inbuilt 3GL utility which perform those additional checks. So, basically if a table has a lot of DAL checks and validations, it will lead to higher time if you go with DAL but lesser time with DB.

But, off-course DAL is the best option to go with. At least it prevents garbage data and saves you from a lot of headaches.