Steve Hutchesson posted some ASM code that can replace the PB JOIN$() function for certain special cases and I've incorporated it into my SQLiteningServer build and it seems to be running solidly during my initial testing. I haven't been able to benchmark the improvement to SQLiteningServer itself, but mcat$() is running roughly 5 times faster than JOIN$() in my tests, so in theory, it should help the SQLiteningServer respond to client requests for data quicker.
I made the following changes:
First, save the following code block as mcat.inc:[code]' mcat$() developed by Steve Hutchesson:
' Alternative to JOIN$. (Dec. 29, 2017)
' https://forum.powerbasic.com/forum/user-to-user-discussions/powerbasic-inline-assembler/768261-alternative-to-join/page2
'
I made the following changes:
First, save the following code block as mcat.inc:[code]' mcat$() developed by Steve Hutchesson:
' Alternative to JOIN$. (Dec. 29, 2017)
' https://forum.powerbasic.com/forum/user-to-user-discussions/powerbasic-inline-assembler/768261-alternative-to-join/page2
'