not to dissuade you, or anything, but I am guessing that making it work for mySQL, Oracle, MSSQL etc is no easy task. By all means though, I guess we gotta start somewhere!
Tomek On Wed, Jun 17, 2009 at 9:56 PM, AJ Mercer <[email protected]> wrote: > In regards to databases, I have been thinking in the back of my mind, that > perhaps cfconponent attributes could be extend to include > - primaryKey="TRUE" (default false) > > - > foregnkey="path.to.componet.PropertyName[,path.to.componet.PropertyName2]" > or > -references="path.to.componet" > - foregnkey="PropertyName[,PropertyName2]" > > The fourQ would create the ALTER TABLE statements to create the indexes. > > Could also have > -isUnique="TRUE" (default false) > to create a unique index > > > Thoughts / Comments? > If there is enough interest, and the Deamon guys think it is > doable/reasonable - I might even give it ago myself. > > 2009/6/18 modius <[email protected]> > >> >> On Jun 17, 2:44 am, Chris Roth <[email protected]> wrote: >> > There must be something I can do to root out the cause and improve the >> > performance. My "publishers" (two highlevel marketing dept reasonably >> > sophisticated users) are getting very frustrated and muttering things >> > like "Sharepoint" and "Frontpage" and other horrible things. They >> > really want to off load work to "Contributors" but there is no way >> > with the current performance of the webtop, I can start training them. >> >> A few things I might suggest for increasing performance of the webtop: >> - upgrade to 5.1.5 (we are always adding performance tweaks as we >> find them) >> - make sure the JVM is tuned; FarCry is designed to soak up memory, >> so its essential that the JVM has enough memory allocated >> - make sure CF is tuned; turn on trusted cache! >> - optimise the database; because applications vary so enormously its >> all but impossible to predict what indices will be required on >> database tables. You must profile the database and add indices where >> needed -- for large data-sets this will have a potentially *enormous* >> impact. >> - check the environment; things like disk fragmentation can have a >> significant impact on performance (especially if trusted cache is >> turned off) >> - check table sizes for farLog and refObjects. You may need to >> periodically truncate farLog and rebuild refObjects if the audit table >> is getting unwieldy. >> >> With respect to the tree, how many nodes do you have in the tree? As >> Blair mentioned, 5.x has a new permissions structure that is built and >> cached for the tree. This unfortunately means the initial tree build >> is relatively slow, but subsequent builds are very fast. It may make >> a big difference if we put up a loading graphic indicating that the >> tree is building its cache rather than presenting users with nothing. >> Might be we have to rethink the caching model entirely for big trees. >> Let us know. >> >> All the best, >> >> -- geoff >> http://www.daemon.com.au/ >> >> >> >> > > > -- > AJ Mercer > Web Log: http://webonix.net > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry -~----------~----~----~----~------~----~------~--~---
