Results 1 to 6 of 6

Thread: Data Bag Version 2 with JSON support

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2018
    Posts
    32

    Data Bag Version 2 with JSON support

    Property Bag alternative - Data Bag Version 2 Class
    This is an alternative to Property Bag class. It supports all variable types except vbObject, vbDataObject and vbUserDefinedType.
    (For the vbVariant , it now only supports byte array.) Now supports JSON. It has all methods same as Property Bag class.
    Now I optimized the class for maximum performance. I tried different for speeding up such as hashing, binary sorting and insertion. Attached Project has a comparison
    of Property Bag, Collection , Dictionary etc.
    Supported types:
    • vbEmpty
    • vbNull
    • vbInteger
    • vbLong
    • vbSingle
    • vbDouble
    • vbCurrency
    • vbDate
    • vbString
    • vbBoolean
    • vbVariant(used only byte array)
    • vbDecimal
    • vbByte


    Name:  SS.jpg
Views: 823
Size:  35.0 KB

    Demo Application :
    DataBagV2.zip

  2. #2
    Hyperactive Member
    Join Date
    Jun 2016
    Location
    España
    Posts
    506

    Re: Data Bag Version 2 with JSON support

    very good work.
    error over flow in TrickHastTableAdd
    Greetings

  3. #3

    Thread Starter
    Member
    Join Date
    Jan 2018
    Posts
    32

    Re: Data Bag Version 2 with JSON support

    Thanks. I tried hard to beat Property Bag and Collection, but I couldn't.

  4. #4
    Hyperactive Member
    Join Date
    Jun 2016
    Location
    España
    Posts
    506

    Re: Data Bag Version 2 with JSON support

    I put Debug.Print i in the for
    and every time he stands on the same ,in 32768

  5. #5
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    5,871

    Re: Data Bag Version 2 with JSON support

    The maximum value of an Integer is 32768
    So if you have or expect more values then declare these basic variables as Long instead of Integer

  6. #6

    Thread Starter
    Member
    Join Date
    Jan 2018
    Posts
    32

    Re: Data Bag Version 2 with JSON support

    Quote Originally Posted by yokesee View Post
    I put Debug.Print i in the for
    and every time he stands on the same ,in 32768
    in frmDataBagTest
    Const iterations As Long = 100000' reduce this to a lower number , to a 100
    then check the debug values . And also there is a hidden command button(UDT Array List) to check the values in collection. Make it visible then you can see the debug values.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width