1 Reply Latest reply on Oct 25, 2007 5:32 AM by Mircea Markus

    using a proper Date format

    Hooman Behmanesh Newbie

      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.


        • 1. Re: using a proper Date format
          Mircea Markus Master

           

          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.