We are thinking of using ProjectWise Connect Edition version 10.00.03.49 to store approx. 10 million files within a single datasource. Is this feasible or does ProjectWise have some limitations on how many files or how big of a datasource can be in size?
ProjectWise is installed on Windows 2016 Server and uses Microsoft SQL Server 2016.
I'd talk to your account manager to get more in depth on the issue but in general the limits of ProjectWise are the limits of the underlying systems. ProjectWise can handle the same number of files in a directory and files sizes that your Windows 2016 server can handle. The limits on tables in ProjectWise database is what SQL Server 2016 allows. 10 million documents can be easily handled by those systems.
The reason I suggest getting together with your account manager and Bentley technical people is there are probably a lot of issues besides just file sizes and database sizes you'll want to know. Network speed and latency greatly affects how usable ProjectWise is, throwing 10 million documents in a single folder will kill performance. Indexing for full text search maybe an issue that you need to handle carefully with 10 million documents, etc...
Hi there, how about having approx 6,000 files with say 10 versions of each file in one folder?
That's 60,000 files unless I'm misreading. It will handle that fine as long as the windows storage can handle it. You don't need to worry about paths being too long as PW fixes that in its design.
when you have 60,000 files in one ProjectWise folder and you use ProjectWise Explorer, opening the folder in explorer just to view the files will take FOREVER. It has to return all that data for every single file. If you must have all 60,000 in one folder create a custom view with absolutely the minimum number of columns on it. Just Name would be best if you can.
Turning off "View All Versions" would be a big help here as it would reduce the number of visible files, and therefore the amount of data returned, by 10.