Bablosoft

Reuse DB

Support
  • L

    I have 2 bots using the same DB, when 1 bot adds new accounts to the DB while the other bot is creating accounts, I use the Reload Resource function but when refreshing the threads it will take out the lost accounts. Duplicate , is there any solution for that . Thanks

    0

  • G

    Reuse system and if code problem

    Support
    0 Votes
    2 Posts
    542 Views
    FoxF

    @BerkeT said in Reuse system and if code problem:

    If have test_123 I'dont want to using Get_code
    How can i do this ?

    declare variables before using them

  • Y

    my DB stopped working

    Support
    0 Votes
    4 Posts
    836 Views
    Y

    i decreased the list from 333k to 100k and it works now along with sorting function. but as my bots run it will increase again in size. what would you guys recommend?

  • Y

    value in db cant be found

    Support
    0 Votes
    2 Posts
    535 Views
    FoxF

    @yourfriendkarol said in value in db cant be found:

    action: select records by criteria
    filter: SomeField contains/equals this string/expression "42×342" wont find it.

    i saved this as string in db. now i cant find it as string nor as expression. not as equals and not as contains.

    btw this happens with similar strings 342x23 too

    for now i can remove them from db..but i cant find them with this script.. so i have to get their ID to remove them

    anyway just reporting this as bug

    it must have something to do with special chars:
    [180281272] [17:20:39] Thread #1 : Skipped and removed because can't find: follow—your–dreams.
    [180281272] [17:20:41] Thread #1 : Skipped and removed because can't find: 421×42.
    [180281272] [17:20:43] Thread #1 : Skipped and removed because can't find: forever–dopeless.
    [180281272] [17:20:45] Thread #1 : Skipped and removed because can't find: 1–nfinity.
    [180281272] [17:20:47] Thread #1 : Skipped and removed because can't find: 423×42.
    [180281272] [17:20:49] Thread #1 : Skipped and removed because can't find: fragmentary–girl.
    [180281272] [17:20:51] Thread #1 : Skipped and removed because can't find: 402×42.
    [180281272] [17:20:53] Thread #1 : Skipped and removed because can't find: 472×42.
    [180281272] [17:20:55] Thread #1 : Skipped and removed because can't find: fragic–magic.
    [180281272] [17:20:58] Thread #1 : Skipped and removed because can't find: forever–devoted.
    [180281272] [17:20:59] Thread #1 : Skipped and removed because can't find: 42×452.
    [180281272] [17:21:02] Thread #1 : Skipped and removed because can't find: floral–vintage.

    here the hyphen is not normal and in other lines X is not typical X.
    i was able to store it but not perform actions on it.

    nvm my bad ignore this post

    store the data in the database in base64

  • Y

    solution for massive database data check other than select db by criteria (high I/O)?

    Support
    0 Votes
    2 Posts
    1017 Views
    AllisterA

    @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

  • Y

    How do you compare values from database? Like closest date to current date from DB entries?

    Support
    0 Votes
    1 Posts
    834 Views
    No one has replied