I use the Oracle Store exclusively for work and have not had any problems with transactions or locking, but that is not to say that there aren't other issues. With Oracle the biggest issue is the limit on properties to about 8000 bytes. This effects group sizes and revision history information. There are work arounds available.
Understand that I have never used the file store backend, so take this with a grain of salt, but the biggest issue I have heard about the file store is speed when dealing with large collections of files. The file store depends on extensive caching to achieve performance because of the way it stores properties and collections (in xml files). I have yet to enable lucene support (full text and property indexing) in our configuration but it is my understanding that this improves performance for many operations in all of the stores. I think that which ever store you use, you need to be prepared to tune your configuration. Slide's default configuration is just that: a default. It doesn't enable many useful features, is not tuned for memory usage or performance and is simply a good starting point. There are lots of helpful hints in this list archive and the Wiki and there are users with experience on this list who are willing to help. -----Original Message----- From: MARENDY, Anthony [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 8:33 PM To: Slide Users Mailing List Subject: RE: Data store The problems were mainly in the area of transactions and locking. > -----Original Message----- > From: Kengeri, Raghu Shankar [SMTP:[EMAIL PROTECTED] > Sent: Tuesday, 21 February 2006 17:21 > To: Slide Users Mailing List > Subject: RE: Data store > > Thanks for the reply, my concern lies more in performance. Will > storing data in database yield better performance than file store. It > would be great if you could tell me the problems you faced with database store. > > -----Original Message----- > From: MARENDY, Anthony [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 21, 2006 12:19 PM > To: Slide Users Mailing List > Subject: RE: Data store > > Raghu, > > For what it's worth, we've been running SLIDE over both a file store > and database store. As a general comment, we have had fewer problems > with the file store than the database store. > > Hope this helps. > Anthony. > > > > -----Original Message----- > > From: Kengeri, Raghu Shankar [SMTP:[EMAIL PROTECTED] > > Sent: Tuesday, 21 February 2006 14:33 > > To: Slide Users Mailing List > > Subject: Data store > > > > Hi, > > I would like to know from all of which is better, database store or > > File store. I know both of them have their advantages and > > disadvantages but when it comes to slide which is the most prefered. > > Any light in this direction would be very helpful. > > Thanks, > > Raghushankar > > > > -------------------------------------------------------------------- > > - To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > ---------------------------------------------------------------------- > -- > ----------- > This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or > one of its related entities "Suncorp". > > Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or > on > 13 11 55 or at suncorp.com.au. > > The content of this e-mail is the view of the sender or stated author > and does not necessarily reflect the view of Suncorp. The content, > including attachments, is a confidential communication between Suncorp > and the intended recipient. If you are not the intended recipient, any > use, interference with, disclosure or copying of this e-mail, > including attachments, is unauthorised and expressly prohibited. If > you have received this e-mail in error please contact the sender > immediately and delete the e-mail and any attachments from your system. > > If this e-mail constitutes a commercial message of a type that you no > longer wish to receive please reply to this e-mail by typing > Unsubscribe in the subject line. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
