Best wishes
Mohammad

On Thu, May 13, 2021 at 3:18 PM Stobot <[email protected]> wrote:

> I agree with all of the above and add that these are crucial (in my
> experience) for performance reasons. For example I've built company lookups
> of customer statuses for people to easily find information. We have
> something like 100 locations, and 1000 customers per location - so 100,000
> customers in total. Comparing the two ways:
>
> 1. 100,000 customers doing a search is *very* slow
> 2. Making 100 data tiddlers of 1000 indexes each runs quite well
>
> Every once in a while I see either posts on "wiki is too big" when it's
> filled with simple lists and I know in at least *some* of the cases they
> could benefit from this structure.
>

Very interesting results!


> While this thread is here, I'd just just throw out there again that while
> there's a indexes[] filter operator, there's not a corresponding values[]
> one. This comes up every now and then and it would be very useful, but I
> don't think any of the people that have the skills to add an operator must
> use them like I do. To illustrate the use-case, I can iterate through the
> 100,000 customers and manually look for the ones with say an "active"
> value, but I can't just return a list of customers with the "active" value
> in the filter.
>


> On Thursday, May 13, 2021 at 4:59:06 AM UTC-4 TiddlyTweeter wrote:
>
>> Ciao Mohammad and TW Tones
>>
>> *Right!*
>>
>> I also think it worth noting a couple of things that maybe not used that
>> much yet ...
>>
>>    1. TW Data Tiddlers will take WikiText. That is quite UNlike most
>>    regular databases! Basically, you can use one dictionary to present
>>    anything! And pre-formatted!
>>    2. You can DUPLICATE INDICES in different dictionaries (Normally in
>>    TW every title is ONCE only. In DIFFERENT dictionaries you can INDEX with
>>    the same pseudo-title). That gives the possibility to do a crude
>>    "relational database".
>>
>> Just thoughts!
>> TT
>>
> --
> You received this message because you are subscribed to the Google Groups
> "TiddlyWiki" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/tiddlywiki/e3cdfd59-92fc-4d36-8a9f-e0e36a59cea0n%40googlegroups.com
> <https://groups.google.com/d/msgid/tiddlywiki/e3cdfd59-92fc-4d36-8a9f-e0e36a59cea0n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/CAAV1gMDZrjkeHQXRCq8-JooG8eiHbgFz%2BFNwYtMoCyn9YWu5GA%40mail.gmail.com.

Reply via email to