On 06/22/2012 06:13 AM, Stephen Russell wrote: > On Fri, Jun 22, 2012 at 7:29 AM, Jeff Johnson<[email protected]> wrote: >> I am looking for an affordable desktop computer. The motive is to have >> one in my laboratory and recommend one similar to my customers. Main >> applications are my VFP9 application& Outlook. The number of records >> in tables are over 10,000 and there are document folders that hold >> several thousand files. The latter seems to be the sticky point with >> most systems. The OS seems to have a difficult time handling so many >> files in one folder. The application has no problem because they are >> all indexed. >> >> So what would be a good processor, ram, and hard drive specification for >> this type of computing. Also, my hardware guy builds my systems with >> ASUS and I have been very happy with them. >> >> Any recommendations will be appreciated. > --------------- > > Subfolders! Ever hear of them? > > Just because you can fill your trunk with bags so cement, doesn't mean > you should drive around like that all the time. > > In doing document management for a printing outfit we found that the > 1000 files in a folder was slowing down our app. For a printed > Document that we made the client may have submitted 2,3,+ documents to > us to combine. We were putting all docs in a single folder. We > rearranged the system to follow the path of the GUID for the actual > document's ID we created. CC44136F-E64A-47CB-B949-EF155932DE47 > became: > Became > <root> > CC44136F > |- E64A > |-47CB > > We found the limit on the SAN to be 2,560 docs in a single folder to > be the killing point for the OS. > > > Steve: Yes, I've heard of them. ;^) One customer of my many has issues with this amount of documents. I want to recommend a system that will work for him as well as everyone else. I also have a lot of files in a lot of folders. So the number of folders on my system needs to be addressed with any new system.
Thanks, Jeff --------------- Jeff Johnson [email protected] (623) 582-0323 www.san-dc.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
