Hi anyone have the experience of using fluentd with questdb?
2 months ago
hi @Balachandar Ganesan thanks a lot for your demo! it’s pretty awesome to see such activities. 👏🙇one tip to attract more people to your demo: check-in the C# project source code unpacked. currently it’s in a zip archive. it means people cannot use GitHub UI to browser the source. One has to download the zip and open the sources locally. that creates a barrier, I believe you could get more views by having it as a plain project.
👋 Does QDB cache request? For example:
If a table changes only once a day.1. During the day 100 million requests are made to that table (identical SQLs) - can QDB be configured to “cache” the request somewhere and keep it for the day (or until the table changes)?
2. What about if the SQLs are different, but the whole table is cached somewhere?
2 months ago
1. Qdb doesn't cache requests but it does cache query execution plans (depending onquery.cache.enabled, query.cache.block.count & query.cache.row.count) . They get invalidated on table matadata change .
2. Table data may be cached in OS cache .
OS cache is volatile and also depends on what other apps on the server do . If there's little load from other apps and a table is the most queried one then there's good chance data is in OS cache (it's "hot") and table is mapped by qdb .