using a proper Date format

[hoom]

Hello,

Would you please advise a proper format for dates, we have a huge data and need to optimize the cache to find more as possible data in cache instead of requesting for creating them. the current date format is dd.MM.yyyy which is a single attribute in fqn (i.e. 24.10.2007)

/root

 /10.12.2007 --> from Date

 /11.12.2007 --> to Date

 /Data1

 /Data2

do you think that using a format like 2007/10/24 or 24/10/2007 and put every date part as a single fqn would improve or worsen the cache?

/root

 /10
 /12
 /2007

 /11
 /12
 /2007

 /Data1

 /Data2

Thank you.

[mircea.markus]

need to optimize the cache to find more as possible data in cache

Do you need queries like: 'I need all the cached data from 3 Jul 06 to 14 Apr 09'? If so organizing the cache as follows might make the query very flexible as you can specify any boundaries. This results in as much as possible data being returned.

/root
 /2006
 /01
 /01
 /data1
 /data2
 /02
 ...
 /31
 /02
 /data1
 /data2
 /2007
 ...

From a cache performance perspective, it doesn't really matter if you hold your that deeper in the cache, as the intermediate(structural) nodes are not costly.