I am interested in what you eventually have chosen, no experience here on this scale, although soon want to setup such exact project, then not for different departments and users but for different clients, so kind of similar.
My feeling says i prefer to setup different projects for each client (think for my situation you have to, can't put numerous clients on one project i suppose), but when it's about a couple of departments it would be better to merge it in one. Then again i don't have much experience on that scale of using Farcry and how it all works on performance etc, so might not seeing all pro's and con's. Already made a choice? On Dec 12, 4:53 pm, Jeff Coughlin <[email protected]> wrote: > Tomek, > > > It seems that either way, you're going to need to do coding of most > > of the display functions. I understood the suggestion to be the > > following: extend all of the basic types with a hidden field > > "department" that is populated from the LDAP directory. Then you > > would have to code the main display functions (objectAdmin, library, > > etc.) to always include "where department IS > > #session.dmProfile.department#" in the queries. That way, you could > > keep things under one install. > > An interesting idea. I'd have to think that through a little more > though (I can see things going badly). > > > However, perhaps one other aspect to think about is database size > > and speed. With the amount of things in the refObjects table (just > > 60 depts * 300+ pdfs = 18,000 in just pdfs) then you add in all the > > rest of objects that need to be stored (profiles, logs, etc) and you > > get a whopping database I would think. Just wanted to point that out > > though! > > Fortunately I'm not worried about table sizes. This client is using > MSSQL Enterprise. I've run MSSQL databases with tens of millions of > records per table and have not had an issue in the past going all the > way back to SQL 7 (as long as your DBA sets up the DB and tables > correctly). But thanks for the concern there (a valid point where in > some databases you could see some serious repercussions or a poorly > managed DB can get very slow). > > Regards, > > -- > Jeff Coughlin > Web Application Developerhttp://jeffcoughlin.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
