Can i use hourly and daily partitions together?

Community Support
,
1

https://learninghub.kx.com/forums/topic/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?..

2
  • 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