• kdb+

  Can i use hourly and daily partitions together?

  Posted by k-mambo on February 24, 2022 at 12:00 am

  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?…

  k-mambo replied 8 months, 1 week ago 2 Members · 1 Reply
• 1 Reply

• 

  eohara

  Member

  February 24, 2022 at 12:00 am

  – 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