Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Code Snippets / [DBP] - fast string concatenation (functions attached]

Author
Message
Bored of the Rings
12
Years of Service
User Offline
Joined: 25th Feb 2005
Location: Middle Earth
Posted: 9th Jun 2017 11:55 Edited at: 22nd Sep 2017 19:11
Here are 3 functions that will allow you to concatenate large strings quickly in DBPro:

+ Code Snippet

+ Code Snippet

+ Code Snippet

Do with it what you will, improve on it, comment on it, anything you wish.

Uses Matrix1 and Styx Plugins.

I'll post some example usage shortly, at work at the moment so doing this quickly.

[update-here is a small usage example code only. If you run it with the functions included it will also generate a text file. Open it up with wordpad (as it's faster than notepad) and do a search on "took" without the double quotes. On my Pc using the new concat strings functions took 6 secs and about 44 secs to do the same the with normal string concatenation. I will be improving the code when I get some more time. ]

+ Code Snippet
Professional Programmer, languages: SAS, C++, SQL, PL-SQL, DBPro, Purebasic, JavaScript, others

Login to post a reply

Server time is: 2017-10-24 01:08:26
Your offset time is: 2017-10-24 01:08:26