Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
System Performance
- Thread starter KevinFSI
- Start date
Hey Kevin,
How are things going these days? I've been so busy this past week I've hardly been on the forums.
My gut feeling on this one is that the more data in the fields, the longer CF's execution time will be so null fields should be less cpu demanding. You can always use the getTickCount() function to find out what parts of your script are taking the longest time.
<cfset x = getTickCount()>
......
more code
.......
<cfset y=getTickCount()>
<cfoutput>Execution Time: #evaluate(y-x)# milliseconds</cfoutput>
I think you'll find that if you're executing queries again Sql server, the queries will be returned quickly and the <cfoutput> section will take the bulk of the execution time. You can also try this with null values and then without to see what the difference is.
Were you just curious about the effect of Nulls or are you experiencing slow script times?
Good luck,
GJ
How are things going these days? I've been so busy this past week I've hardly been on the forums.
My gut feeling on this one is that the more data in the fields, the longer CF's execution time will be so null fields should be less cpu demanding. You can always use the getTickCount() function to find out what parts of your script are taking the longest time.
<cfset x = getTickCount()>
......
more code
.......
<cfset y=getTickCount()>
<cfoutput>Execution Time: #evaluate(y-x)# milliseconds</cfoutput>
I think you'll find that if you're executing queries again Sql server, the queries will be returned quickly and the <cfoutput> section will take the bulk of the execution time. You can also try this with null values and then without to see what the difference is.
Were you just curious about the effect of Nulls or are you experiencing slow script times?
Good luck,
GJ
- Thread starter
- #3
Doing fine. How about yourself? I haven't been on here either. No lack of work around here these days!
Good suggestion, I'll give it a try. I'm not experiencing slow script times, but I'm working as one user on a dev machine, so I don't know what it will do with a load on it. It runs just as quickly as any other query.
I'm toying with the idea of using a where clause to exclude the nulls, but at the same time, I want to see those fields that were null, so I'm not sure what I want to do at this point. Kevin
slanek@ssd.fsi.com
Good suggestion, I'll give it a try. I'm not experiencing slow script times, but I'm working as one user on a dev machine, so I don't know what it will do with a load on it. It runs just as quickly as any other query.
I'm toying with the idea of using a where clause to exclude the nulls, but at the same time, I want to see those fields that were null, so I'm not sure what I want to do at this point. Kevin
slanek@ssd.fsi.com
strantheman
Programmer
Hey Kevin and GJ
I can't say for sure that this is a valid way to emulate how a system might react to a lot of users, but ive been running programs in background on the server to forceably slow it down by eating up RAM, clock, and the network.
Ill usually go to download.com, search for "game demo" and start 3 big downloads.
Then ill open photoshop and start a batch job of opening a folder full of 5mb pictures and doing a series of commands before exporting to another larger file type.
If im lucky there's about 10-15 minutes of -%50 clock and -%50 RAM atleast. The network load is negligible, but it really does show you a difference.
Whatya think? Is that a valid test at all or am i just whistling dixie?
I can't say for sure that this is a valid way to emulate how a system might react to a lot of users, but ive been running programs in background on the server to forceably slow it down by eating up RAM, clock, and the network.
Ill usually go to download.com, search for "game demo" and start 3 big downloads.
Then ill open photoshop and start a batch job of opening a folder full of 5mb pictures and doing a series of commands before exporting to another larger file type.
If im lucky there's about 10-15 minutes of -%50 clock and -%50 RAM atleast. The network load is negligible, but it really does show you a difference.
Whatya think? Is that a valid test at all or am i just whistling dixie?
- Thread starter
- #5
- Status