Hi Stuart I believe UK Agricultural Department is running a big site although probably not high transaction throughput. There are a number of Credit Unions and Banks that are running large sites and would have high transaction through put.
I assume this is the Post Office processing accounts for rates, electricity, etc, so this is mostly flow through transactions? Issues to look at would be if the individual files will exceed 2Gig, if you are using publish/subscribe that the buffer sizes will handle the volume and what happens if the computer publishing to goes offline. For this size of processing you might want to look at introducing Message Queue processes that are now in UniVerse 10.1 Regards David Jordan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart Astley Sent: Wednesday, 21 July 2004 7:54 PM To: [EMAIL PROTECTED] Subject: [U2] [UV] Database size Platform: Sun V1280, Solaris 9, UniVerse 10.0.8. We currently have a file consisting of ten distributed files handling 250,000 transactions a day (approx. 60 million per year). Each part has 10 indexes. Soon we shall be looking into increasing our transactions to 1,000,000 per day (approx. 240 million per year). Does anyone out there handle similar volumes or had experience with these volumes on UniVerse? Disk space is not an issue and any guidelines would be appreciated. Thanks. Stuart Astley GeoPost UK **************************************************************************** ********** Information contained in this email or any attachment may be of a confidential nature which should not be disclosed to, copied or used by anyone other than the addressee. If you receive this email in error, please delete from your computer. Virus Warning: Although this email and any attachments have been virus checked, it is the responsibility of the recipient to ensure that they are virus free. No responsibility is accepted by Geopost UK Limited for any loss or damage arising in any way from their receipt, opening or use. We do not authorise the making of contracts via email or the Internet. Opinions expressed in this email or any attachment may not necessarily represent the views of Geopost UK Limited. All emails received and sent by Geopost UK Limited may be monitored to protect Geopost UK's business interests. **************************************************************************** ********** ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
