If you saw my code you saw that the only thing I was doing was a select statement to the SQL server. The reason the second test was so fast was because I left caching on, so that I would get a more real world result.
As I said earlier, I have no reason not to use JTDS, as a matter of fact if they were faster I would be more than willing to use them instead of Microsoft's drivers. As it stands now though, I have not been able to justify their use . Even though the tests on your website show the drivers being faster, it was done in a very specific manner, I need the drivers to work in a ColdFusion enviroment and if they aren't faster in ColdFusion then they are no use to me. I ask anyone else to run the same test I did. A loop that runs 100 times is by no means breaking a site, and in my opinion there is no real reason to bog a server down by running it for hours at a time. Real world users should be reading from the database significantly more than they should be doing anything else. Bob Everland ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191736 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54