I have written a log system for those people that do not have access to their win OS web logs. I tried to test which would be more efficient... run the log table in the database/datasource that is used by the cold fusion system the person is running or to have them setup a new datasource for this plug in.
It makes sense that it would be more efficient to run this plug in from the same datasource that runs your application. But, I did some tests on my laptop and it only seemed to make a difference on the initial hit to the new log datasource. Running this from the same datasource the new log process took 40 milliseconds. If I ran this from a different datasource the initial run took 110 milliseconds and after that it only took 40 milliseconds. I assume the extra 70 milliseconds when running from a separate datasource was cold fusion making the initial connection to the datasource. Basically, I am curious to see if anyone sees any efficiency problems with running 2 different datasources in the same code versus running just one. thanks, kaigler ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
