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.
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.
60k rows in a database with the same parent ID should not even make a database blip unless indexes are set up incorrectly. Granted, if you have a security nightmare and don't use best practices, that could make it horrible. So, assuming that's not an issue, what is PWExplorer doing to make it so slow? If you have slow servers or slow client machines, your mileage will be less.
.... a factor of 10