-
Can i use hourly and daily partitions together?
I currently using a hourly partition, but If inquire for more than a month, the performance is poor due to many folder inquires. Do i have to configure a separate hourly or daily partition database process? Is this a disadvantage and constraint of KDB+?
— +
the data stored as a file seems to be based on not modified again. If need to modify past period data, what is the most efficient way?…
-
1 Reply
-
– Can i use hourly and daily partitions together?
Not in the same HDB, see here:
14. Introduction to Kdb+ – Q for Mortals (kx.com)
If you are looking to change from hourly to daily partitions, you could move your older partitions to a separate database and merge them into dates. You would then have to query this database separately. Or you can look at converting all of your existing database into daily partitions
Log in to reply.