I don't really mean database load since that is a direct factor of how fast the CF app is servicing requests. I mean whether the actual database has the proper indexes, etc., as well as whether your queries are properly optimized. The biggest bottlenecks in the vast majority of applications are caused by poor database design or by inefficient SQL, so I would start there and make sure those things are actually working as well as they can.
If the bottleneck actually turns out to be the CF server itself due to the sheer volume of traffic, then you need to improve the server hardware or add more CF servers and create a cluster. I'm betting that this will not turn out to be the problem because 200,000 page views is not an extremely huge number. On Mon, Mar 31, 2008 at 3:39 PM, Ronan Lucio <[EMAIL PROTECTED]> wrote: > > Brian Kotek escreveu: > > Yes it sounds like you very badly need to do some kind of load testing > > on this application. Because the questions you have cannot be answered > > in any other way. > > I agree. > > > Regarding the data, if the gateways are returning queries, then I'm > > not sure what the issue is. Your initial questions were about using > > CFCs as Value Objects, but if the majority of data being used is > > already in the form of queries, then that shouldn't be an issue. > > I agree. I really don't have a solid opinion about that. > > In the same way I'd like to improve/refactor our code to a more OO > approach, I'm afraid to give extra weights to the server. So I asked you > to know how do you deal with this performance issues in well accessed OO > applications. > > > You will, of course, need to run tests to ensure that your database > > and queries are properly optimized, and look into caching the queries > > if you can. Again, at this point everything is conjecture because > > until you actually run load tests there is no way to know where the > > bottlenecks are or what you memory usage looks like. > > The database server is OK, no extra load. > The Bottleneck is the CF Server. (simultaneous requests). > I have already did a JVM Tunning. I got better after that, but, perhaps > it can be even better. > > Thanks, > Ronan > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" 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/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
