Jason Sas 6.Nov.08 08:30 PM a Web browser Domino Designer 6.5.6; 6.5.5 FP3; 6.5.5 FP2; 6.5.5 FP1; 6.5.5; 6.5.4 FP3; 6.5.4 FP2; 6.5.4 FP1; 6.5.4; 6.5.3 FP2; 6.5.3 FP1; 6.5.3; 6.5.2 FP1; 6.5.2; 6.5.1; 6.5 Windows XP
We currently have a 6GB database which we have been told is crashing the server it resides on because it is so big.
The database contains legislation which users can search on (Go to www.legislation.vic.gov.au and then 'Law Today'). You can browse alphabetically or search on keyword/date. I have been asked to discuss the feasibility of splitting this database into smaller databases to fix the problem of the server crashing and also to resolve future performance problems. I would think we would split alphabetically (Eg, A-K, L-Z).
What I would want to be able to do is:
- Allow users to search documents from A-Z on the main page, but depending on the letter they click, open up the documents in the relevant database
- allow users to search by keyword or date, but search across the 'split' databases and allow the users to click on the search results 'transparently' without having to know in which database the document resides.
I'm just after some general informatio as to whether you guys think this is feasible and if so, how big a job this would be. I'm happy to post code if you need it.