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. 

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.

Reply via email to