This is the scenerio:
I have heirarchy of folders, with files at the very bottom of the tree of folders.
It looks like this
1996->19960101->fileFolder->files
19960202->fileFolder->files
19960302->fileFolder->files
19960402->fileFolder->files
19960502->fileFolder->files
and so on...
the 19960101 represeents 1996=year, 01=month, 01=day
now, initially i had these all gouped in a catalog at the root of 1996
so the catalog had the directory 1996, and all underlying folders and files.
The problem here was, the quering was slow and inaccurate. That is because, the directory contained over 200,000+ documents.
Here is what I want to do, but have tried many ways, and was unwilling to do it. I want to break it down into quarters
ie
catalog 1996q1 would have the following included in the directory:
1996->19960101->fileFolder->files
19960202->fileFolder->files
19960302->fileFolder->files
catalog 1996q2 would have the following included in the directory:
1996->19960401->fileFolder->files
19960502->fileFolder->files
19960602->fileFolder->files
Now, I can not restructure the files, because they reside on a seperate machine, and other systems are
dependant on how they are set up.
Is there a way to do this... If more information is needed, respond back... I have been stumped on this one for awhile.
Thanks in advance for any help.
I have heirarchy of folders, with files at the very bottom of the tree of folders.
It looks like this
1996->19960101->fileFolder->files
19960202->fileFolder->files
19960302->fileFolder->files
19960402->fileFolder->files
19960502->fileFolder->files
and so on...
the 19960101 represeents 1996=year, 01=month, 01=day
now, initially i had these all gouped in a catalog at the root of 1996
so the catalog had the directory 1996, and all underlying folders and files.
The problem here was, the quering was slow and inaccurate. That is because, the directory contained over 200,000+ documents.
Here is what I want to do, but have tried many ways, and was unwilling to do it. I want to break it down into quarters
ie
catalog 1996q1 would have the following included in the directory:
1996->19960101->fileFolder->files
19960202->fileFolder->files
19960302->fileFolder->files
catalog 1996q2 would have the following included in the directory:
1996->19960401->fileFolder->files
19960502->fileFolder->files
19960602->fileFolder->files
Now, I can not restructure the files, because they reside on a seperate machine, and other systems are
dependant on how they are set up.
Is there a way to do this... If more information is needed, respond back... I have been stumped on this one for awhile.
Thanks in advance for any help.