-
Dec 10th, 2020, 07:51 AM
#1
Thread Starter
Member
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
Demo Application :
DataBagV2.zip
-
Dec 10th, 2020, 07:10 PM
#2
Hyperactive Member
Re: Data Bag Version 2 with JSON support
very good work.
error over flow in TrickHastTableAdd
Greetings
-
Dec 10th, 2020, 11:52 PM
#3
Thread Starter
Member
Re: Data Bag Version 2 with JSON support
Thanks. I tried hard to beat Property Bag and Collection, but I couldn't.
-
Dec 11th, 2020, 08:19 AM
#4
Hyperactive Member
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
-
Dec 11th, 2020, 11:46 AM
#5
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
-
Dec 12th, 2020, 12:16 AM
#6
Thread Starter
Member
Re: Data Bag Version 2 with JSON support
Originally Posted by yokesee
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|