Mark, if you store the mail files on the filesystem rather than in the DB (Blob ,clobs whatever ) the queries are real simple
That mailfile name is store in the DB rather than the mail itself... like: Is this the email address valid at this domain Get me all the mails in folder x read mail x Delete mail x etc. Simple ,...of course make sure you store your mail files on a RAID device with backups etc.. You can store the mails in the DB of course and get the benefits from replication, backups etc in oracle .. Justin > -----Original Message----- > From: Mark Woods [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 20, 2002 2:25 PM > To: inFusion Support List > Subject: Re: [iMS] IMS Option Pack - would you recommend it? > > > forgot to mention - I'm probably going to have to use Oracle, so > I'll have > to port the option pack query code to oracle. Please tell me there are no > complicated stored procedures. > > > Mark > ==^======================================================= This list server is Powered by iMS "The Swiss Army Knife of Mail Servers" -------------------------------------- To leave this list please complete the form at http://www.coolfusion.com/iMSSupport.cfm Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/iMSDevelopers.cfm List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/ Note: You are subscribed as [email protected] ==^=======================================================
