Hi Jeff, I appreciate the suggestions, and I'll try them, but here's why I think it is farcry: when I turn on debugging look at the results!
Total Time Avg Time Count Template 1843 ms 1843 ms 1 CFC[ D:\farcry\farcry_core\packages\farcry\stats.cfc | logEntry(sessionId = 98AE40B6-3048-85AF-18775C32B7AC85CC, browser = MSIE 6, os = Windows 2000, remoteIP = 66.235.23.152, navId = 5B356ED4-3048-85AF-18DD1F70F3DD8361, locale = [complex value], referer = http://pwp.flyingmountain.com/index.cfm?objectid=5B356ED4-3048-85AF-18DD1F70F3DD8361, userid = Anonymous, pageId = 5B356F31-3048-85AF-18B11B8B36B67BA7) ] from D:\farcry\farcry_core\packages\farcry\stats.cfc 1843 ms 1843 ms 1 D:\farcry\farcry_core\packages\farcry\_stats\log.cfm 1843 ms 1843 ms 1 D:\farcry\farcry_core\tags\farcry\_farcryOnRequestEnd.cfm 1843 ms 1843 ms 1 D:\farcry\farcry_core\tags\farcry\statsLog.cfm 1843 ms 1843 ms 1 D:\farcry\testsite\www\OnRequestEnd.cfm 1579 ms 1579 ms 1 D:\farcry\farcry_core\tags\navajo\display.cfm 1579 ms 1579 ms 1 D:\farcry\testsite\www\index.cfm 813 ms 813 ms 1 CFC[ D:\farcry\farcry_core\packages\types\dmHTML.cfc | getDisplay(objectid = 5B356F31-3048-85AF-18B11B8B36B67BA7, template = displaypageStandard) ] from D:\farcry\farcry_core\packages\types\dmHTML.cfc 703 ms 703 ms 1 D:\farcry\testsite\webskin\dmHTML\displaypageStandard.cfm ... and that's just the start of the list, listed in time, desc. Total CF processiong time: 3453 ms (as compared to 140ms for non farcry sites) When I look at how long the queries took with farcry, most are 0ms. the next most common is 16ms, a few are 47ms. Two exceptions: q in farcry_core\admin\includes\cfFunctionWrappers.cfm select objectid, objectname, nlevel from nested_tree_objects where objectID IN (etc) --this takes 406 ms and qInsertLog in farcry\_stats\log.cfm takes 1843 ms! and then, generally, there are SO many calls to the db. I DO have CF admin set to maintain connections..I wonder if it is doing that. I'm using a brand new jdbc driver... I wonder how many people are using mySQL with farcry and if I should use something else instead?? I could test with Sql Server but it would be on a remote db, so probably slower given the huge number of queries that happen? Thanks for your continued assistance, Maya --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
