
--
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 tiddlywiki+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/e5c63c57-f6e8-41f5-a404-a5f6a5f28e0cn%40googlegroups.com.
1. 100,000 customers doing a search is *very* slow2. Making 100 data tiddlers of 1000 indexes each runs quite well
... while there's a indexes[] filter operator, there's not a corresponding values[] one... 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.
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.
>>> Jeremy considers data tiddlers as a mistake, so he doesn't want to add more complexity to the core, to give it better support. If we have better support in the core, more users will use it, which makes it harder to get rid of it.@PMario Why does he consider data tiddlers a mistake? This seems related to my recent post here: What's the point of JSON tiddlers?
Ciao Mohammad and TW Tones
Right!I also think it worth noting a couple of things that maybe not used that much yet ...
- 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!
- 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 tiddlywiki+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/32b8d336-f637-4b1a-9fb3-82be1f804928n%40googlegroups.com.
On Thursday, May 13, 2021 at 1:31:22 PM UTC+2 si wrote:>>> Jeremy considers data tiddlers as a mistake, so he doesn't want to add more complexity to the core, to give it better support. If we have better support in the core, more users will use it, which makes it harder to get rid of it.@PMario Why does he consider data tiddlers a mistake? This seems related to my recent post here: What's the point of JSON tiddlers?That's not so easy to explain, but I'll try. It's part of the "selective refresh" mechanism of TW. ..."Selective refresh" means, that widgets or parts of a widget are only redrawn, if their parameters have been changed.Eg: You have 2 checkboxes, that are connected to the same data-tiddler, which may be seen as an advantage.cb1: <$checkbox tiddler="test" index=1 checked="selected" unchecked="" default=""> Selected?</$checkbox>
cb2: <$checkbox tiddler="test" index=2 checked="selected" unchecked="" default=""> Selected?</$checkbox>
So with this setup, whenever you change the "selected / index" status of cb1, the core also has to recalculate the "selected" status of cb2, because the tiddler "test" has been changed. ... This wouldn't be the case if there would be 2 different tiddlers.You may say, that's not a problem, because it's convenient. ... Yes it is convenient and for this example it isn't a problem. ... BUTIf you have several 100 indexes, that are "connected" to completely different UI elements, it starts to be a problem: You will have to redraw a lot of elements, that don't really need it.--------I also think, that using data-tiddlers as "configuration" and / or "lookup-tiddlers" that don't control visual elements, is convenient. And it won't go away anyway.hope that helpsmario
--
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 tiddlywiki+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/1de0941f-227f-4624-8ebb-ba139c9ad710n%40googlegroups.com.
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* slow2. Making 100 data tiddlers of 1000 indexes each runs quite wellEvery 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 TonesRight!I also think it worth noting a couple of things that maybe not used that much yet ...
- 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!
- 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 tiddlywiki+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/e3cdfd59-92fc-4d36-8a9f-e0e36a59cea0n%40googlegroups.com.
Eg: You have 2 checkboxes, that are connected to the same data-tiddler, which may be seen as an advantage.cb1: <$checkbox tiddler="test" index=1 checked="selected" unchecked="" default=""> Selected?</$checkbox>
cb2: <$checkbox tiddler="test" index=2 checked="selected" unchecked="" default=""> Selected?</$checkbox>This is exactly the case with the Todolist plugin! and it is quite common to have several 10s of todo items connected to three four dataTiddler!So, I should be aware to not use one Todolist with many items!
Wow @PMario - I can't believe I missed your plugin! It's extremely impressive how much flexibility you've put in there. Thanks!!
I did create the keyvalues plugin: https://wikilabs.github.io/editions/keyvalues/That allows you to directly show the key and the value plus a separator. The operand is used to allow filtering. It's easy to use it as a values[] operand, with the right parameters.
So if you have problems using it, let my know at github: https://github.com/wikilabs/plugins/issues
IF I need advice on its use could the open a Discussion on your GitHub?
--
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 tiddlywiki+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/1de0941f-227f-4624-8ebb-ba139c9ad710n%40googlegroups.com.
One more question:If you add a new key:value to a dataTiddler in Tiddlywiki, does it recreate the whole tiddler again? Seems yes ( I am talking about this with your recent discussion on immutability of tiddlers)
If s, then a big dataTiddler like the one has few hundred keys, then it will affect the performance
--
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 tiddlywiki+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/2e0bf9f9-5aa3-415c-b918-3b5bffe42798n%40googlegroups.com.
In the Todolist plugin which is highly based on dataTiddler you can enter any kind of wikitext!It even uses macro calls like <<fixme>> to show an icon for todo item!So, yes this part needs to be documented much better, many do not know!