RTTSoftware Support Forum

PDF Explorer => General => Topic started by: straxx on September 07, 2010, 08:50:08 AM

Title: max. number of PDF Files
Post by: straxx on September 07, 2010, 08:50:08 AM
Have you any recomendations of the max number of PDF's you can index an maintain in a database?
I have ~100'000 Files per year each around 10-15 Pages. All scanned and fulltext indexed.
Is it possible to manage this amount of documents with PDF Explorer for searching over the webserver?
Title: Re: max. number of PDF Files
Post by: RTT on September 07, 2010, 03:50:47 PM
The physical limit of the database is imposed by an 2GB maximum file size of any of the database files, and that size is, for the database files that grows larger, imposed by the amount of the metadata of the indexed PDFs.
I currently have a test database with more than 250'000 indexed PDFs,  with some very larger custom metadata fields (to test some things) and the bigger database file is only 250MB (and this is much bigger than what happens in a normal scenario, because of these dummy filed custom fields), so 100'000 is peanuts.
But for that amount of files, be sure to use a good directory hierarchy.  Don't put all these PDFs is the same directory, or you are going to have problems with the Windows Shell itself.