Can i use hourly and daily partitions together?

[k-mambo]

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

[eohara · Accepted solution]

- 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