Global List Function

[hellomembersha]

I am willing to pay to have a global list variable to work with a list across multiple threads.
I am fine with this function also being released to the community, open sourced and potentially installed into standard bas if possible as I could see it being very useful for many other users.
I prefer to have a regular or support from the forum build this function.

[GaG]

You have "resources" in BAS.
They act as global lists and are
meant to use accross multiple threads.

[hellomembersha]

@GaG I have come across a issue i have not been able to solve.
bas database has a 10k limitation. when i run a script that involves a database of more than 10k rows it will stop the script once the 10k is reached. I am needing a way to bring in more than 10k resources into the script but only once as it is hardware intensive to repeatedly load this many resources, so it must be done only on application start. Have you had this issue before?

[Fox]

@hellomembersha said in Global List Function:

@GaG I have come across a issue i have not been able to solve.
bas database has a 10k limitation. when i run a script that involves a database of more than 10k rows it will stop the script once the 10k is reached. I am needing a way to bring in more than 10k resources into the script but only once as it is hardware intensive to repeatedly load this many resources, so it must be done only on application start. Have you had this issue before?

I worked with a much larger database, can you describe the problem in more detail?

[hellomembersha]

@Fox 10k resources is the limit when using database.
Lets say my database has 25 thousand emails in it, I am only able to use the first 10 thousand than the script closes.
I am using parse csv string and pulling the emails form the database the user selects.

[Fox]

@hellomembersha said in Global List Function:

@Fox 10k resources is the limit when using database.
Lets say my database has 25 thousand emails in it, I am only able to use the first 10 thousand than the script closes.
I am using parse csv string and pulling the emails form the database the user selects.

I have created a test script that works in 2 stages:

• stage 1 - fills the database in a loop with 50,000 random strings
• stage 2 - outputs rows from the database to the log via resource

Tests have shown that the resource is loaded in parts of 10,000 lines without any errors

Test script: 2684.xml

Video of the work (I periodically paused the video recording until the number of free resources was reduced to 150. The script was run in 100 threads, so the BAS interface freeze quite a lot):

The script worked correctly for almost 6 minutes and correctly displayed more than 20,000 records from the database: