CPU usage per page
Try going into the debugging area if CF Admin and making sure that it is logging pages that run longer than X seconds. Set it to 60 seconds or so and watch which files show up in the logs. Then, run those files in development with the full debugging turned on and see if 1) there are sql statements or stored procedure calls that take a long time 2) if the page calls many sub pages and any of them take a long time to run. Most likely you will identify a few key pages that everyone runs that are very cpu intensive. Here are a few of the things I 'fix' rewrite queries that take a long time if possible (adding indexes to tables may help) rewrite stored procedures look for queries that are called on every page or repeatedly on the same page (in a loop) that can be cached. You may find that you have 3-5 queries in your application.cfm page that run for every request that pull back the same information. Running these could take a tenth of a second or more, adding load to CF, the database, lag time to connect, etc. If you have a page with a loop with a query inside it and the only thing in the query that changes is the primary key, try rewriting the query so that you can put it on the outside of the loop and use a query of query inside the loop. i.e. you have a query called 100 times (loop 1 to 100), each time returning 1 row. Rewrite to return all 100 rows, place outside loop. Inside loop, query the 100 row record set for the individual row. this cuts database connects from 100 to 1. If you are running MS Access, get rid of it :-) ~| 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:207939 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
Re: CFMAIL and Bulk Email Strategies
In this case, Yes it will make a difference, we provide open house times for the weekend, and reasonably we can assume a large proportion of users put in their work address and/or wont check their email after 5pm on a Friday night. Makes sense why you need it to send faster. I know that CF4.5 was slow, 5 was faster and MX/6.1 much faster in the email area. Sadly, I think 6.1 still has some problems with email from a stability point of view, but it can be made quite fast. Check the mail threads setting in CF. That may help, may be set to 3 or some such. If its a constant 12/minute it may not be anything lame like defragging the hard drive. Have you looked into your ISP? If you aren't running your own mail server maybe your ISP is limiting the throughput for spam control reasons. In fact, maybe your smtp/mail server has a setting that limits throughput out. Either way, 12/minute is WAY slower than it should be, even in 4.5. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184672 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
Re: CFMX for sale
Susan, If you won the raffle via a CF or Macromedia user group, I urge you to please reconsider your sale.Sure, getting some $ for it is nice, but I'm pretty sure that MM did NOT intend for the winners to be reselling the software on the open market. If users start selling the software that MM gives us to promote the groups, we seriously run the risk of being cut off.They (our sponsors at MM) have to fight to get us the software as it is. If you are unable to use the CF software and it came from a user group, please contact your user group manager and maybe we can work out a way to swap the software for something that will be of use to you. Ryan, Kansas City CFUG Manager [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Firefly
MM stated in the big user group presentation that they were hoping for mid month availability. You may want to try contacting customer support. Maybe they will let you put in an order for the new studio and give you a copy of firefly to test and play with in the meantime. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: OT: Paid by a percentage of the gross?? Anyone?
Jeffry, Thanks for the recommendation that others read my reply from before! I love being referenced! I reread my message from before and stand by it. I'm still owed over 10k by my former employer who 'deferred' employee pay for a while and managed to not write us contracts stipulating such. They have since closed their doors and I seriously doubt I will ever get my money. Everyone should CYA and remember that if they don't cover themselves and their opponent/business partner does, they will loose. Almost without fail, someone comes out the winner with the other 'loosing' and the more you protect your self the closer to 50/50 you can make it. Being fair and nice only goes so far in this day and age, you have to watch out for yourself. Ryan -- Date: Sun, 08 Sep 2002 11:20:59 -0400 From: Jeffry Houser [EMAIL PROTECTED] Subject: Re: OT: Paid by a percentage of the gross?? Anyone? Message-ID: [EMAIL PROTECTED] I have a few things to say, but instead of stealing others words as my own, read this thread: http://www.houseoffusion.com/cf_lists/index.cfm?method=threadsforumid=1 1displaydate=04/26/2002 I strongly recommend reading Ryan Hartwich's post (first reply ) at least twice. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Tracking Hits
Jim, I can think of 2-3 things you can do that should minimize problems. 1) Set 1 Application variable in application.cfm using cfparam to count and update each and every page load (i.e. a line sets the cfparam default=0 name=application.totalhits and then cfset application.totalhits = application.totalhits +1. Use a secret page that runs on a cfschedule to save the application.? Variable to a database for archiving purposes, this could run every few minutes to show escalating hits. 2) Do #1 above, but add some variety and extra variables for the different pages you want to track. Optionally, do this with structures. For instance, set a bunch of variables/keys to 0 and then for all pages update the 'allpage' by 1, for the index.cfm, do that one specific key, and maybe a few key pages you would update those specific keys. Use a secret page that runs on a cfschedule to save the application.? Variable to a database for archiving purposes, this could run every few minutes to show escalating hits. 3) There are ways of doing #1 above with a modification to store IP#s and a timestamp. With a very robust 'admin' page you can then show a color coded page of who is 'online' at any specific time. This could be a rather large hit to the server in RAM however if the 500-1000 hits/min are unique users versus 20 users hitting different pages. Either way, these pages probably need to lock the variables (CF5 and below) and might consume CPU and RAM if you program them incorrectly. Ryan Date: Wed, 4 Sep 2002 22:12:07 -0500 From: Jim Vosika [EMAIL PROTECTED] Subject: Tracking Hits Message-ID: 01c2548a$04f46220$6401a8c0@JIM I have a web page that, when it goes live, I am expecting to get about a 500-1000 hits a minute. What would be a good way to track this number? I wouldn't want to make a database call or open a flat file each time the page loads but my curious mind would like to see hard numbers. Are there any good painless ways to do this? Thank you, Jim Vosika SoftwareSuperMall.Com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFGrid and its display width
Josh, Sadly, I have been repeatedly annoyed with CFGrid and am about to drop using it. Here are a few of the reasons and they include yours: 1) Same problem you are having, Java compatibility problems presumably 2) CFGridUpdate sucks...plain and simple, it just doesn't work consistently 3) forcing database updates manually using grid submitted info doesn't work consistently, who knows if it is DB specific or not (i.e. values with '' won't save consistently 4) scrolling problems with the grid 5) inability to define individual widths to each field in the grid 6) single row of text for each data record, so really long text fields pose massive display and editing problems because you can't show the grid with 2-4+ rows of text for each row of record 7) As far as I can tell, no appreciable functionality upgrades or bug fixes between CF 4, 4.5, 5, MX I feel for you...I haven't found much online support, examples, or help for these issues. Likewise, I searched for a drop in Flash replacement for the grid to see if there would be a fix using that route, nothing...no custom tags either. Ryan Date: Thu, 1 Aug 2002 13:34:11 -0400 From: [EMAIL PROTECTED] Subject: CFGrid and its display width Message-ID: 001e01c23981$a63cc4c0$[EMAIL PROTECTED] I'm having a problem, and I've looked through the archives and the macromedia support forums, and I've seen mention of other people having this same problem as early as CF5, but haven't seen a resolution on any of those threads. Could be I'm missing it, but I'm not sureSo What happens, is that a random amount of the time (maybe about 15%) CFGrid loads up in a page, and the gray java box goes accross the width of screen as it should, but the grid piece only goes about half-way accross the screen. It also cuts off columns that would have been farther right than its border, and does not have a scroll bar to see them with. If I refresh, let it display, see the results, and refresh again, it happens consistantly at a random interval (IE: I can always get it to happen, but the amount of times required is not constant). 1. Has anyone else seen this? and 2. Any fix? I'll include the code, for what it's worth cfgrid height=150 query=ContactInfo name=gridContacts insert=no delete=no width=800 cfgridcolumn name=FullName width=170 header=Name href=../Contacts/contacts.cfm?Action=ViewContactID=#ContactInfo.Contac tID# cfgridcolumn name=Title header=Title width=170 Cfgridcolumn name=WorkPhone header=Phone width=150 cfgridcolumn name=Email header=Email width=200 href=mailto:#ContactInfo.Email#; /cfgrid Josh Remus Network Administrator FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk-list V1 #156
Brook, I'm not that experienced with large table sets, but I imagine that 1 big table would be easier to use. 20M/25K = roughly 800 emails sent. If each time you attempt to create a new table, either for each sender (max 800 times if each sender sends only 1 set), or less if some send 2+, then you have a number of different tables. You still have the same insert problems with 800 tables versus 1 table, and since inserts are considerably more overhead than a large select, ignore this part of the problem. Now think of the programming time to build the logic to keep 800 tables separate (naming conventions, etc.). Also, what happens if user 432 wants to send a 2nd email, does 432 get a 2nd table created or do they enlarge their first table? If they enlarge it, now you have 799 tables and table 432 is 2x times larger than the others. As you start having redundancy the table sizes grow just like they would with 1 large one. Defeating your purpose. MS SQL 7 shouldn't have any problem running 20M records. Heck, I have heard of Access running with 500M records, though I think this is well into the extreme for Access. Another advantage to the 1 large table, if you are only sending out the emails periodically (ie. Not every 5 minutes) than you can rebuild the index on the table more frequently and keep some of the same speed optimizations that a smaller table that isn't indexed (because you forgot to do it and didn't think it was necessary on a small table). I'm not a guru syntax coder, but I suspect you will have a harder time pushing 20k emails out at a time through your server than you will using the database. Likewise, RAM is cheap, CPUs are cheap. Your programming time and future maintenance is not. No one will miss a quarter of a second in query time. If you have to, use a set of stored procedures to do all of your database lookups. Ryan - Date: Fri, 26 Jul 2002 22:16:28 -0700 From: brook [EMAIL PROTECTED] Subject: Creating tables on the fly or using one big table Message-ID: [EMAIL PROTECTED] I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If each user is sending email campaigns of 25,000 recipients + what is the best way to record and later generate reports on this data. Would it make sense to generate a campaign recipient table on the fly for each user of the system upon registration or first use? This way the total records per table would be a bit more manageable for report generation later. Is this sound practice? Or should I just have one huge table shared by all the systems users. I could see this table growing to 20,000,000 records within time. Would select statements and report generation on subsets of data from this monster table be slow? (SQL7) Are there benefits to leaving all of the data in one big table as opposed to generating this table on the fly for each user, therefor keeping the total size down? The table which holds the email campaigns recipients will need to be used in a number of joins to include additional email delivery stats. What do you think? Brook FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFGrid / CFGridColumn - display 1 long row as 2+ rows?
Does CFGrid, in 4.5, 5, or MX have the ability to display text fields as a row that is taller than 1 row high? I.e., I have a table with a really wide text field (500+ characters) and want the line to wrap onto a 2nd or 3rd physical row on the grid so that massive scrolling is not required. I can get the grid to make rows taller, but the text doesn't wrap when it is displayed or selected for editing. This makes using the grid for viewing/changing wide tables and columns almost impossible. I have looked through books and MM's site forums and have seen no direct answer to this problem. Thanks, Ryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Triggers/Stored Procedures - MS SQL 6.5
We have code within Cold Fusion which does updates to a SQL Server database. These updates execute triggers on different fields in the database. Within the triggers, stored procedures are called. When the updates are done in Cold Fusion, the trigger is started but the stored procedures do not execute properly and the update that kicked off the trigger does not complete successfully. When the exact same update statement is done in ISQL, the trigger and the stored procedure execute properly. We have also had some success when different, less processing intensive stored procedures are called from the triggers. Are there settings within Cold Fusion or within SQL Server that will alleviate this issue? Ryan Hartwich [EMAIL PROTECTED] 913-642-1600x223 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.