1. First I started off with a blank client variables database (just easier since it was already made and I was on a box that wasn't used)
2. Next I made a file called test.cfm and included this in it, this is the write test for the CF datasource.
<cfset text = "aassskjkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbboooooooooooooooooooooooooooooooooooooooooooooobbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb">
<cfloop index="i" from="1" to="1000">
<cfquery name="testquery1" datasource="cfsession">
Insert into cdata(cfid,app,data)
values('#i#','#i#','#text#')
</cfquery>
</cfloop>
3. Next I took away the write then made a query that just read what I put in.
<cfset text = "aassskjkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbboooooooooooooooooooooooooooooooooooooooooooooobbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb">
<cfloop index="i" from="1" to="1000">
<cfquery name="readquery1" datasource="cfsession">
Select *
From cdata
Where cfid = '#i#'
</cfquery>
</cfloop>
4. Now delete all data in your database and start over again, but change the name of the queries, I changed my to have a number 2 instead of a number 1 so there would be no caching issues.
The results
Write CF Datasource 3345 ms
Read CF Datasource 6990 ms
Write MS Datasource 3044 ms
Read MS Datasource 6369 ms
So the MS driver is faster, by 300 ms after 1000 read and writes, could help you bigger guys. Hope this helps anyone out there.
Bob Everland
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
