HAL questions
DBHold and DBFlush
Paul Timms
4-28-25
Operating system: macOS
Are DBHold and DBFlush still useful? I've seen them in some source HAL but they may be very old HAL functions. I'm wondering if there good reasons to use them, for performance optimisation?
Reply
Bror-Erik Kotiranta
4-28-25
I havent really seen them in use for over 10 years. Maybe if you´re using db accelerator but that ain't in use either really
Reply
Paul Timms
4-29-25
From what I've read, using these will store the updated records in memory and then write them to the database in bulk, instead of each record writing to the database in turn. So perhaps there's still a small performance benefit, even now? It would be useful to get some advice on this from a C-level developer.
Reply
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Re: Server crash with EInvoicing function
Gastón Salomone
Hi David, I´ve done lost of test, including rebuild database, add more level of verbosity, click on every check on Log Messages on database and still, once that function is called server crash. ...
15:59 9 May 2025
Re: DBHold and DBFlush
Paul Timms
From what I've read, using these will store the updated records in memory and then write them to the database in bulk, instead of each record writing to the database in turn. So perhaps there&apo...
17:53 29 Apr 2025