Andrew, > So I appreciate your help on this matter, but seriously I am going to be > recommending we move away from Farcry based on the answer that Geoff has > outlined below.
The phrase 'unbelievable' comes to mind right about now. 1. If you'd base recommendations on a product based upon this then I really wouldn't want you to be my vendor of choice. 2. If you'll read Geoff's response you'll see that in both cases he has helped you out. Firstly with 'pruning' of the dmStats table (and he even suggests other means of collecting stats) and in the second with deleting data from dmArchive. Note that in his final response (see below) he actually gives you a way to clean these 'orphaned' records in the refObjects table. What he does say is that "Having orphaned dmArchive objects in this table should not affect the system adversely". In others words...it won't result in a system meltdown if (and only if) you didn't use the repair utility! >>> Are you referring to the refObjects table? If so you can run the refObjects repair utility (ADMIN > COAPI utils) after you have truncated the dmArchive table. refObjects is simply a lookup table for determining typename. Having orphaned dmArchive objects in this table should not affect the system adversely. But as always, I would recommend backing up your database prior to any operation of this kind. >>> Andrew this forum and many others are about a knowledge share when the community can find the time. We'd all like more time to help each other out but sometimes that just isn't case as I would hope you understand. Posting 3 messages within a few hours and having a tantrum when you don't get the response you want if quite frankly childish behaviour which really doesn't foster the community spirit. Please remember that we are all here to help each other, also don't forget to read responses carefully as you might find that you actually did get the answer you were looking for. Michael On May 31, 2:07 pm, Andrew Scott <[EMAIL PROTECTED]> wrote: > Geoff, > > Yes you can politely remind me that this is not a commercial support forum. > However when I read the wiki it stated as I posted that most automate this > process. Yet when you go looking to see how people have automated this > process there are no examples what so ever. > > Secondly, someone like yourself could have been a bit more descriptive about > what is needed in the first place. I did say that I am not that familiar > with the relationships etc, if any and that I am seeking advice on that > matter of how to go about it. > > And yet when I made mention of (yes the refObjects table) it wasn't > discussed by anyone. > > Now if the wiki says that most people automate this procedure, that means > there are people here who could have answered that question. Yet I really > only got half the answer to my question, now that might be because I didn't > explain myself that well. But when you are learning, we don't always say > what you guys already know. > > I just felt that when I asked a question, and only got half an answer to > what I asked I am left wondering why the Farcry CMS system is not fully > documented after all this time. I even went looking for the API's to 3.0+ > and all I can find is 2.03 API's. I understand that you guys do this and > have it opensourced, but a bit more documentation wouldn't go astray:-) > > Now, the thing as I stated I want to truncate and remove all objects that > are older than a certain date (archived objects) the reason for this is that > our client has a limit on the size that database can be, I made that very > clear and wanted to know what I need to do to remove these references. So if > I truncate the dmArchive table, if there is any other table that has link > based on that dmArchiveId then I want to remove that as well. > > What is the point of only doing half the job? If we have the chance to clean > the DB properly then we should do that, and I find that leaving orphaned > data behind a lack of care by any programmer. And if that is your answer > about leaving orphaned files behind, then I am seriously debating on the > future of Farcry as its developers do not care about the product at all. > > So if I was to go back to my Boss and say well we can do this, but it is > going to leave this and that and I am not sure if it is going to hinder the > rest of the application. And then show him the response I got, how is that > going to be any good for Farcry in the future? > > So I appreciate your help on this matter, but seriously I am going to be > recommending we move away from Farcry based on the answer that Geoff has > outlined below. > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd.www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > > Behalf Of modius > Sent: Wednesday, 30 May 2007 4:05 PM > To: farcry-dev > Subject: [farcry-dev] Re: Still seeking an answer Geoff : RE: [farcry-dev] > Re: Audits and Archives > > Having orphaned dmArchive objects in this table should not affect the system > adversely. > > Regards, > > -- geoffhttp://www.daemon.com.au/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
