I have the same problem.
Unfortunately I don't see how the string matches regex function can help.
It allows to check a variable, but I don't see how I could check all the records in a table?
Any ideas or other solutions?
Is there any way, any way I can use columns as well, maintaining data in single column is difficult.
I request Bas Developer to integrate Read from CSV file with coloumns as well. Than nothing would be better than this. Currently with ubot we can play with csv files very easily.
Here is how you can get it:
var elements = document.getElementsByClassName("txtSize2");
//Where X is the id of the right element in array
@yourfriendkarol said in solution for massive database data check other than select db by criteria (high I/O)?:
What I do is:
get some data
select by criteria db action, it gives u list
if length of that list > 0 it means record is in db already - continue. If its not there, then it adds.
its good way to do it but i think with many threads my I/O is on max and it gets kinda slow, but maybe im wrong and its something else slowing me.
i basically have such thing as i described above running 24/7 and cant speed it up for some reason nomatter how many threads I add.
CPU, memory, disk, is all ok on low usage, only I/O high
This all depends, is the data within the table long/a lot? 1million + with a high character rate?
Have you tried other Database actions and/or filters to minimize the search criteria?
Would an external MongoDB you set-up & configure yourself might change the I/O bottleneck?
External DB: http://wiki.bablosoft.com/doku.php?id=how_to_setup_mongodb_server