Re: Is CF still relevant?
The cost of PHP versus CF not counting server license is not that far off. If you want top of the line performance with ZendCache you will need to pay a hefty price (www.zend.com). If you want to use Zend's php editor you have to pay a price too. The caching system is part of CF already. WIth JSP, Level 4 JDBC drivers will cost from several hundred to thousands depending on your database and number of connections. That alone will overshadow the cost a professional license. None of the open source solutions are free or even close to free to get the performance and connectivity of a CF enterprise or even professional edition. I think what it comes down to is stability and how you use the products. PHP doesn't have a nice error catching system like JSP or CF. JSP has shown to be the slowest of all platforms. PHP for windows is as buggy as your backyard so switching to linux/bsd means extra training/cost to your company. But I do agree allaire should setup to the plate and at least give an estimate on the CF 6.0/JSP edition timeline. Even an estimate will satisfy a lot of us. xing - Original Message - From: "Chris Giminez" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, April 21, 2001 12:54 PM Subject: Re: Is CF still relevant? I have only dabbled in other programming languages, but from what I can see, CF does most everything the others do, but does it easier. The high cost keeps it from being as popular as ASP and others. I know lots of developers who are spending lots of time learning PHP since the Enterprise version of CF is just too expensive to put on the server. There is just not enough demand for a higher priced account. Too bad Allaire/Macr... There are a lot of potential clients out there if it were just more affordable. Chris Giminez Cyber Scriber I probably should not join this particular thread because I will probably be seen as very biased BUT. But I am a relative newbie as an employee of Allaire now Macromedia. My experience with using ColdFusion and briefly trying ASP is more relevant since I have used ColdFusion since late 1995-96. In reality ColdFusion should have died long ago as it has an appreciable up front cost. But it did not die in the face of alternatives that have no up front costs. In fact rather than ceasing to exist it grew exponentially in use. Also, the ColdFusion community has never seemed small to me as I struggled with and was presented with solutions to challenging issues, time and time again. Now, we have the honeymoon and final marriage of Allaire and Macromedia. I do not know what will eventually come out of this but I do know it will be fed and nurtured with ideas from all the worldwide developers and users of both former Macromedia and Allaire products and I do know that we are only limited by our own imaginations. My personal opinion is that now would definitely be the wrong time to move away from ColdFusion for anyone with a desire to be involved in the future of the Internet and the Web. Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.macromedia.com -Original Message- From: Joseph Grossberg [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 12:28 PM To: CF-Talk Subject: Is CF still relevant? Now, before you dismiss this as a troll, please let me elaborate. This isn't so much an instigation or a whine as it is a call for us to take a step back and reevalutate things periodically. Over the course of my career as a web programmer/developer, I have worked with a variety of sever-side languages and technologies: ColdFusion, ASP, JSP, PHP, Perl and Python. I like some more than others, but I'm not an evangelist for any; they each have their uses. And I recognize some of CF's strengths: easy to learn for people who know only tag-based HTML or don't have significant programming experience; built-in admin tool; specialized editor; comes with pre-built tags and web-based administrator. There are also major flaws: broken/sketchy tags; no XML parsing; not OOP; relatively small community; etc. Right now, I work at a web development firm that is primarily "a CF house" (besides me). Our more senior programmers are looking at honing their CF skills, while our less experienced webmasters are trying to learn ColdFusion. But, I can't help but wonder whether they are wasting their time. Would they be better off spending their time learning ASP, Java or another non-CF solution? Why or why not? And how would we tell if and when it was time to give up CF and try something else, as all but the most stubborn experts in also-ran languages (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating Systems (Amiga) have resignedly done? Lastly, why do *you* still use CF? Is it because it's what you're best at, and you don't want to try something
Re: CF Using 90-100% of processor time (911!)
Not sure if anyone else has mentioned this yet but there is a very rare and random cfmail bug that cause exactly the cpu usage you have described. Once in a blue moon CF 4.5.X blurps out an empty/0K email queue in the C:\CFUSION\MAIL\POOL folder or wherever you installed CF. Look for a 0K file and remove it if you find it. Once you do that and restart the service everything should return to normal. It's extremely rare but it does happen. xing - Original Message - From: "Bonnie Betts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 9:27 PM Subject: Re: CF Using 90-100% of processor time (911!) Question on this thread: Would any of the log files give you a hint as to which pages were accessed when the server started using up resources? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "Steven A. del Sol" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:35 PM Subject: Re: CF Using 90-100% of processor time (911!) I believe your problem is that on one of your pages you are timing out. Check to see if you have a page where you are passing a Alpha into a numeric field. It will not necessarily crash if you have a number in the sequence somewhere but it can stall your cfserver for hours. Also, set your timeout's lower and set server to restart on two timeouts. This error can happen with datefields too. Hope you find your problem it took us three weeks going through thousands of line of code to fine one date field not validating, throwing errors and causing the server to have cfserver at 95% to 100% of the memory usage. GOOD LUCK At 12:48 PM 4/16/2001 -0400, you wrote: My server developed a problem today. CFServer.exe is using almost all of the available processing time. I've tried stopping and starting the services and the NT box, but as soon as I start CF again it almost immediately grabs all of the processor time. I'm running NT and CF 4.01. We've had this application up and running for a little over a year now and have only started having this problem today. I'd greatly appreciate any suggestions, since this has my Web site running at a crawl. TIA! Russell Conway HallofSports.com, Inc. 351 West 22nd Street New York, NY 10011 P (646) 638-2500 F (646) 638-3444 http://www.hallofsports.com .. . . where the legends live on ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error Catching Overhead - Performance Data?
Don't want to do more than I need to so I will try to get the answer here first. Has anyone done any performance testing with huge blocks of CF code with and without nested/non-nested CFTRY/CFCATCH code? It would be interesting to see if anyone has experienced any significant difference between the two styles in terms of raw performance. xing ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Procedure and Function (Rambling thought)
I kinda think the new CF functions as poor man's objects without the protection and inheritance stuff. I don't agree with the fact that objects are too complex are not suited for scripting languages. If used right, they actually save tons of work/time long term and can actually make our programs run faster especially if the app is pretty large in scale. After all, objects are created to ease our programming headaches if used in the right places. CF/Allaire want to capture the enterprise market which is why they have all the loadbalancing intergration so that they can make huge profit margins on the Enterprise editions and the bloated/hugely complex enterprise level projects demand objects to make life a lot easier. I wouldn't be surprised if the spotlight feature for CF 6.0 (hopefully the JSP/pharoh? version) would be objects. It's just a matter of when not if in my mind. xing - Original Message - Subject: RE: Procedure and Function (Rambling thought) I agree! I dont know what the big fuss is about... CF Tags are functions as far as anyone should be concerned - just because they're not implemented in exactly the same way VB, Java, etc implements functions means didley squat... I'll be the first to admit that I'am sometimes frustrated by how CF Tags are carried out but more often then not i thank god that they work as they do, it makes life so much easier when your output is HTML. As for objects - Anyone thinking of using a scripting language to create a program that requires objects should be taken out and given a good talking to. CF is great as the glue that holds together all the objects that we need to create effective websites (DB connections, Email, Files, Forms, etc) but by no means would i use CF to create something as complicated as a credit card transaction gateway - Java is much more nicely designed to do this. In short, i think CF has been brilliantly written to create websites quickly, effectively and under budget - an equivilent website could take as long as 3 times longer if written in C++ or Java... The right tool for the right job - you dont complain when your drill doesnt perform well as a hammer. Regards, Javier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 2:29 PM To: CF-Talk Subject: RE: Procedure and Function (Rambling thought) Sorry, but my wandering mind's gotten the better of me and I've got a concept to throw out for those who might want to chew on an idea (no spitting, please... we just washed the floors). From what I remember from my CS classes (my degree is in Electronics, not CS) functions and procedures are devices that use either an individual or multiple attributes to perform some computation. In the case of a function, at least one value is returned to the calling process. Forgive me if I'm reaching a bit here, but doesn't that remind anyone else of a custom tag or CFX tag? A procedure doesn't return a value, but simply performs an action or actions on attributes passed to it. Taking a bigger stretch, doesn't that sound a bit like an include? Now I know, this is getting abstract, but it seems to my thought process that Allair actually did provide us with a mechanism for performing external functions that can be used repetively across a wide array of applications and scopes. So to throw a kink into the wheel, yes, Cold Fusion does have functions. We simply call them something different: Custom Tags. As for implementing Object Oriented programming concepts, that may be a bit outside the bounds of what can be done. In all honesty, that's okay. I personally hated OOP... especially when I had a PhD that was more interested in researching multiprocessor programming concepts than teaching, but I digress. Sorry for the rant and the ramble... 19 days nicotine free, living with in-laws and looking at buying my first house. All this and I haven't had a drop of alcohol (yet)! Enjoy! C. Hatton Humphrey Cold Fusion Developer Fisher, Towne Associates http://www.fishertowne.com [EMAIL PROTECTED] -Original Message- Hi Haryono, if you refer to your previous posts on this issue, and other peoples subsequent replies ... I'm sure you will notice that CF isn't OOP and we do not make any Your post : http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49020.html My reply : http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49023.html Please take notice of answers when you post a question. Hallo, How can i use procedure and function in ColdFusion? Is this possible to use OOP in ColdFusion? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:
Re: when is CF5 release? (a little OT)
Allaire claims that the latest CF builds are dramatically faster and especially on linux. I have not done any formal tests so I can't say it is true or not. But I can safely say that CF is now finally on a bit of diet. Memory usage has been down significantly across the board on 24/7 servers pumping out loads of pages... I would personally invest in CF 5.0's features based on how stable the betas have been. xing - Original Message - From: "Todd Ashworth" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 7:12 PM Subject: Re: when is CF5 release? (a little OT) OK .. as a diversion from the current topic, is anyone developing stuff for CF 5 based on what they have seen so far? We are building an app that could benifit from some of CF 5's features. We would like to 'build for' CF 5 if it will be released within the next 3 months. Otherwise, we will have to make do with 4.5 and worry about a later version release, well, later. :) Todd Ashworth Certified ColdFusion Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] (p) (803) 328-2868 (f) - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 9:44 PM Subject: RE: when is CF5 release? It's still in beta (version 3.0 at last check). Allaire usually release a couple of "Release Candidates" before shipping final code so it will probably be a few months yet. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Which version of MDAC is best with Cold Fusion 4.5.1
Always get the latest mdac which is at version 2.6 right now. Just go to microsoft.com, select download, select keyword and w2k and type in "mdac" and you see the link for it. It's about a 5mb download. Xing - Original Message - From: "Jeffry Houser" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 9:05 PM Subject: Re: Which version of MDAC is best with Cold Fusion 4.5.1 If it's working, don't change anything. I have ColdFusion and the latest version of MDAC (I'm pretty sure 2.5) running on my machines here just fine. Of course with only one user (me) you don't get a lot of server load. At 04:19 PM 02/27/2001 -0500, you wrote: I think I am currently run MDAC 2.1 (no patches) with Cold Fusion Profesional 4.5.1. Presently we are using ODBC against both VFP and Access databases/tables. Our DBA says that they are running MDAC 2.51.5303.5 elsewhere within the organization. Can and/or should I have our DBA upgrade to the 2.51.5303.5 version?? Will Cold Fusion play nice with 2.5, or should we go to the latest patched version of 2.1 ?? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion FAQ
Nice collection. =) I have a question. Why do you say that OLEDB connection is faster for SQL server than ODBC? I always thought that ODBC is native to SQL servers. Xing - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, February 25, 2001 3:03 AM Subject: ColdFusion FAQ Roll-up, roll-up... laydiees and gintelmin... There is now a ColdFusion FAQ for your deeelectation at http://www.thenetprofits.co.uk/coldfusion/faq/ At the moment it's just a db spewed out on the page. I'll bolt on a search interface when there's a spare minute. And it's populated with peals of wisdom from you chaps and chapesses, so give yourself a pat on the back:-) -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
I'm not questioning whether it's a nice feature or not. I'm just looking for a nice application to put it to good use. From you what you have described, it doesn't save speed or resources in the long run. Currently you'd have to run many queries, but with Query a Query you can run big queries on both and then just combine them into smaller queries with no database/sheet access You are using more ram by grabbing big queries in the first place and then running smaller queries within the large queries in ram so you are still running many queries though not through SQL but with CF. And as the size of the excel sheet data and the SQL counterpart grow in size, the performance gain, if any, will most likely deminish since by grabbing more ram with the large qureries, other system functions might suffer. I'm gonna wait and see more developers test the query on query and see what's the general consensus in terms of performance. Like if a simple SELECT statement on an exisitng query with 100 records on CF would be faster than a SELECT statement directly with db server that contains 10,000 records. It might or might be faster since the db server is optimized for indexes, joins, and other query procedures. Xing You want to know the biggest use for it? Say you've got one table with info in one datasource (SQL Server), but you have other info uploaded in an Excel sheet - you want to compare the data to see what's new in the sheet... Currently you'd have to run many queries, but with Query a Query you can run big queries on both and then just combine them into smaller queries with no database/sheet access If that isn't a bonus, I don't know what is! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!!
Hopefully they do not attempt make this a closed beta. I tried my normal login, which I have had for more than a year now, and I don't see it. I register a new account and it doesn't work either. Maybe we just have to wait till Feb2 for all public access. xing The Beta for 5.0 is available!!! The Beta forum says it's available 2nd Feb and the Beta login says "No Beta Software." - I think you're jumping the gun a little... No, it's on there. The Allaire Beta site doesn't list every product for every user, for some odd reason. I had to try several logins before seeing it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The BETA IS OUT!!! (query a query)
I haven't thought of a kickass problem/solution that would need query a query ability so I'm happy that's it is there to use but not, stoked, at least not yet. =) Have not tested or even had the priv to touch 5.0 yet but isn't just query a query just a search option? So we can do a search for array values, structs, and now arrays which are in a way structs. Hmm..actually, I have yet to use structfind() with queries so I wouldn't know if that works already. Maybe with query a query you can isolate a range of records that fits a new condition on a existing query? but wouldn't that be a waste of ram and sql power to return a large query in the first place that you need to do sub queries on? Basically, I'm trying to find a good problem that would really need the feature and would speed up the performance while not wasting resources. Xing So who's stoked about the Query a Query ability? Pretty damn cool eh? Michael Buffington [EMAIL PROTECTED] (714) 556-3890 x222 http://www.price.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 5.0 (custom functions)
Visited the beta forum and straight from the horse's mouth: custom function ability is not in beta 1. That kinda killed my anticipation for 5.0 since functions can be a poor man's object oriented approach . So we have heard of query on query. Anything else? It better be worth the wait. If they can get rid of location 26 errors with 5.0 and/or give us access to the cf output buffer then I will be more than happy. =) Xing ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Feature of ColdFusion
Hallo everyone, I want to ask some question that related with ColdFusion's feature. What is the meaning of dynamic load balancing? When the traffic is divided up to separate servers in real time. For example. You have 3 servers that's clustered or load balanced to do the same thing. Without the "dynamic" catch phrase, each server will have 33% of the load/traffic. CF enterprise has builtin monitoring tools that checks to see the stress of each server that allows the load to shift from one server to the next depending on the status/health of the 3 servers. So if one is really busy, that one will get maybe 5% of the traffic while the other two will get the rest of the load. What is the meaning of automatic fail over? Fail over protection means when one server goes down, another server, which has been idle, comes in to the picture and takes over the load. Fail over is not load balancing. Xing Thank you for your answer. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Making a noise
It's possible but you won't get it out of coldfusion since it can't control the client side. What you need is javascript, java, or flash. You can use cf to pick what sounds are played but you can't use cf to play them. Xing - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 6:15 PM Subject: Making a noise Just toying with an idea at the movement and wondered if this was possible. If I had a series of .WAV files, eg. 1.wav, 2.wav etc or even A.wav, B.wav etc could I get a CF template to read a number or spell a word on the screen. I assume that you would have to concatenate the wave files somehow with or without launching a player. + Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: +61 8 82332548 f: +61 8 82332000 m: 0418 800 287 + This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Date of Birth question
if you want a lazy answer read the follwoing. Just subtract 1 from your current answer. Xing - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 7:18 PM Subject: Date of Birth question Hey guys/gals! I am currently working on database enabling the www.friendsplus.com.au web site for a friend using, of course, CF. At the moment it is maintained manually using Micro$oft FrontPage 2000 - not very efficient. What I need to do is when a member "Joins" and enters their date of birth (as a Eurodate formatted date DD/MM/ - it's an Aussie site) to calculate their age in years based on the current date (Now()) - dynamically. I nearly had it working except it calculated me as being 33 and not 32 (born December 4 1968). Any suggestions would be appreciated. In the meantime I'll get back into it. All the best. Peter Tilbrook Slave of Friends Plus (rowers required) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Studio and PHP?
CF Studio, with the new versions, already has builtin PHP source code highlighting support. Doesn't have debugging support but good enough. Xing A friend tells me that Allaire's Studio might be supporting PHP in the future - is this true, or complete rubbish? Will -- [EMAIL PROTECTED] -=- www.lukrative.com Classifieds -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: CGI.Remote_Addr and client identification...
Well..one day I decided I had to add extra security to my custom client storage system and what's a better way to do this than to record the IP (cgi.remote_addr) when creating the client instance and verify the IP stored and real-time IP in addition to the cookie keys stored on the browser. However, there was something I hadn't planned and it really surprised me. Turns out, MANY, and although not a very high percentage, low thousands if you have millions, end users having internet connections whose IPs shift from one request to the other! I didn't know this was as wide spread of a practice to pay any attention and no one told me this was even been done. Because of this, hundreds of people complained wildly about being logged off the second they authenticate themselves. Heck, I couldn't verify what they were trying to say until one user from new Zealand, whose ISP has switched to satellite feeds, helped me tracked down the nagging problems. Turns out her connection ranges from .15 - .18 IP randomly from request to request and I assumed she wasn't the only one. So now, the client verification is only done on the first two IP classes(?): 205.111.444.222 is stored as 205.111 for verification. Thought this might save some headaches to some fellow cfers down the road if they ever come across this type of problem. Xing ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF's way of retrieving client data...
We have several default variables associated client states: LastVisited,HitCount, etc So we have two sets of client variable types: custom and allaire's global set. After watching the queries on the sql server through the sql profiler, CF calls two separate queries for each client request. One to the cglobal table for the global/allaire's variables, and another to cdata for the custom variables. Even you "disable automatic global variable updates", which basically renders the global variables useless, CF continues to call two separate sql statements for each request. I can understand why they would do this since the client global variables are in the documentation and thus they should always be there to use but what I don't understand is the lack of the ability to get rid of that overhead, and it can become a major overhead considering it's searching on a string key. And why would they use a string as the search key? Couldn't they just have two int fields, cfid, cftoken, and group them together as the primary key? I would think the int search would be faster considering how many times those queries runs a small improvement can go a long way. And why don't they just use one sql statment and use join to consolidate the two table rows since they use the same key instead of the overhead of two separate statements? Is it just me? Xing testing 1.2.3...testing 1.2.3... ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Audience Profiling
It's less programming and a lot of back end crunching at the end. For every page view, record the cgi.http_referr string, the current cgi.querystring and/or cgi.scriptname, and/or other additional parameters such as the userid/ip address, time, etc...as much unique data as you will need in the long run... once you have the 2gig database sitting idle on the server, use some other environment, not cf, to access the databse and crunch the data and spit out classifications of the user and other stats and possiblity back to another "personalization" database. Also, you have tried weblog analyzers? If all you need is tracking general movement then just crunch the weblogs. xing - Original Message - From: "Roger Lim" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, December 27, 2000 6:48 PM Subject: Audience Profiling Hi, I'm currently planning a project that requires Audience Profiling. Basically the administrator of the website will be able to track the user's movement, like the most frequent visited pages of the site, number of times the user used a certain facility, etc. Any idea how do I go about doing that using CF ? Thanks, Roger ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT Java letdown
Time to throw in my two cents. Java is the best platform, in my opinion, to develop software for mass deployment since you can "almost" have your hava apps run on "most" of the platforms. Mac OS X will bridge the mac gap in the Java race but I do agree that the "write once run anywhere" goal is not really applicable. Java is like a baby that you always have to take care of If you install the wrong JDK, you get 200% performance penalty or it won't run at all. You can install 50 JDKs on your machine and you lose track if you applicationi is running off the right one. To use Java SWING with IE you need to reformat the applet tag with ridiculous object tags. Most complex applets do not even run on the current mac java implementation. Java gui's layout components are very poorly designed in my opinion. I'm exaggerating a bit but the list just goes on. Even the price point of "free" java tools (tomcat, compilers, ides, etc) don't even add up in my opinion. For example, let's say you want to program a JSP application for a high volume site running off SQL 2000. The server and the editors are free. But, and a BIG but it is, the high performance database driver is not included (we can thank MS for that). So, you pay nothing for the development but pay $1000+ (some charge much much more) for Level 4 JDBC (native and fastest) drivers for deployment. Hmmm...if I went with a "commercial" and close-sourced platform like CF (which costs around one grand) but get free ODBC (native to SQL 2000) driver. So overall, there is no economical advantage even though they might lead you to think that. It all depends on your situation but I believe the java way to deliever html is not the cheapest, not the fastest, not the easiest, and not even the most feature complete. To me, java is like been stuck in the middle. It's never the worst or ever the best in any area. It does everything you need but just slow enough or cumbersome enough to make you think twice each time. =) After just going over the ASP.NET specs.docs/tutorials/sample apps I would have to say that ASP.NET has probably the best feature set that I want, as a web application developer/designer, when compared with CF, JSP, or PHP. Xing I know this is OT but a recent thread, along with talk of CF future support, has lead me to once again investigate Java as a possible development language. Mostly client side... I envision including Java applets in web pages to compensate for html limitations Once again, I downloaded the latest versions of all the Java components started taking the tutorial suggested on another thread. Once again, I have suffered a letdown... Things like StarOffice only run on certain platforms Browser support varies on certain platforms (On the Mac, NN IE run different versions of Java Java JavaScript interaction is very limited (NN on windows) Java is still a little slow on the GUI The effect is that "write once, run anywhere" is a goal yet to be accomplished, IMO. Am I missing something or is Java a universal solution... as long as: you run a win OS you run NN I develop on a Mac, I have LINUX system, and can run a windows emulator. If I want to create a platform/browser-independent application, it appears as if the potential gain from using Java is not worth the effort. Geese... UCSD Pascal was a more-universal solution than Java appears to be. What do you people think? TIA Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Compress HTML output]
It's been running like a champ for us over the last three days on a moderately high volume site. I can't imagine that the CFX overhead would be that much higher than ISAPI overhead. CFX_GZip is a good multi-threaded tag... The overhead is most likely on the cache file writes and cache reads. You just gave me an idea for a work around that could be better and faster than all the options we have just discussed. With both ISAPI and CFX, the system has to compress each and every single page output as it is a new one. Might as well store the compress data into the db using CFX_GZip and serve it out of the database. This way, not only do we save CPU time we also save I/O overhead. Serving from the database is much more efficient (ram and cpu wise) in the long run than reading from the filesystem. So we only compress it once every so minutes or hours. With IIS 4.0 you need the recource kit which contains the isapi compression filters. A Now this I did not know... I must give this a try... Look for compFilt.dll and gzlip.dll and deflate.dll Xing ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Compress HTML output]
It's compressed at the server and decompressed at the client. Pretty sure all current browsers support both the deflate(an compression algorithm not the expanding part) and gzip. The decompression is very fast so the end user doesn't even see a difference. Xing Could you please explain how this compression works. I keep seeing this as it is being compressed and decompressed at the server, or is it being compressed at the server and decompressed at the client. Bob Everland -Original Message- From: Zachary Bedell [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 24, 2000 10:26 AM To: CF-Talk Subject: RE: [Compress HTML output] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Not sure if this has been talked about in detail but with the interest in dynamic html compression I will throw my two cents in. And donations of this sort are *always* appreciated! Thanks! ;-) Why use a cfx tag with coldfusion to compress html output when you can use IIS 5.0's builtin gzip/deflate compressors? We're stuck on WinNT4 for various reasons, so using IIS compression wasn't an option for us. Also, for non-IIS users, this CFX version should still do the trick even if their webserver doesn't support compression. I bet the cfx/cf overhead is much higher and not suitable for high volume situations. It's been running like a champ for us over the last three days on a moderately high volume site. I can't imagine that the CFX overhead would be that much higher than ISAPI overhead. CFX_GZip is a good multi-threaded tag... With IIS 4.0 you need the recource kit which contains the isapi compression filters. A Now this I did not know... I must give this a try... By default, you can set IIS to do a "application" level, not "static" level compression, which would compress dynamic content. Go to the "services" tab of the server in the mmc. However, and by default, the dynamic compression only applies ... Very interesting... I will most certainly try this. Thanks for the pointer! Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com Comment: Please use PGP! iQA/AwUBOkYVcKvhLS1aWPxeEQLBawCdFX8/Cx8ZLwFJk2h0u8vHZvxn2IIAoNXC /aYrqpaVDexfyCoWzqU8BwOP =9yi3 -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Compress HTML output]
Not sure if this has been talked about in detail but with the interest in dynamic html compression I will throw my two cents in. Why use a cfx tag with coldfusion to compress html output when you can use IIS 5.0's builtin gzip/deflate compressors? I bet the cfx/cf overhead is much higher and not suitable for high volume situations. With IIS 4.0 you need the recource kit which contains the isapi compression filters. By default, you can set IIS to do a "application" level, not "static" level compression, which would compress dynamic content. Go to the "services" tab of the server in the mmc. However, and by default, the dynamic compression only applies to "asp", "exe", and "dll" extensions. So for it to compress cf streams than you need to use METAEDIT.EXE to modify the metadata which is like the registry but specific to IIS. There you can add "cfm" to the HcScriptFileExtension key under W3SVC/Filters/Compression/+ deflate/gzip. Once done, do a "c:\inetpub\adminscripts\IISreset.exe /restart" in the cmd window and you should see the "inetinfo" process take up much more cpu usage than before. If not then it is still not configured right. You can also use the METAEDIT.EXE to change the compressing buffer size, compression level, etc... I was able to reduce the bandwith usage from 3.3mb/s to 2mb/s which is close to 40% decause in bandwith using level 7 compression. Still not sure if IIS is using GZIP or DEFLATE but I'm happy nonetheless. Xing ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: clientVar storage/multiple CFAS/single storage db
This is a pretty old post but given its importance as related to client variables I want to revist this. I have a system setup where two cf machines are tied together via dns round-robin and share the same database for client storage. As the number of simultaneous users increasesd, the number of users overstepping/intruding into other's client memory space have increased to such as a point that I had to store the IP of the client user as part of the client init and verify the user ip with the client var each time as not to assume the cfid/cftoken on the client browser do actually belong to them. I have not personally reproduced on my machines but given the hundreds of reports this is not a coincidence. Other than the round-robin setup there are nothing special about the way the client vars are stored in the database. Although this problem has been seen more from IE 5 users, it is not exclusively IE. Netscape and IE 5.5 users have also reported this problem. Not sure if SP2 has addressed this problem but I hope somebody here has clue as why this is so. Again, this only surfaces as traffic increases. I have asked users to manually remove all their cookies stored on their browser to make sure it's not the browser's fault. It didn't work. I thought mabye the cfapplication setdomain option was at fault but none of the combinations resolved the issues. The weird thing is that once you overstep into another person's memory space, you will ALWAYS overstep into that particular person's client vars in the future. This is not a you assume a random person's identity every time. CF's client management system somehow remembers you AND someone that you shouldn't be associated with. I have no clue why this is so. In fact, this problem is a bit related to an thread way back when where someone had a perculiar SQL error with CF trying to create duplicate CDATA entries. Forgot who was the original poster but that person had trouble with client states with IE 5 browsers. At first I really didn't believe it could happen to me, will...it has and I'm clueless. The only solution I have, thus far, is to manually verify an additional bit of information (IP adderss) for each client accessed page. Xing p.s. Maybe CF 5 should let us modify the client creation/deletion/verification SQL scripts? It's no secret the generic statements they use and I don't see a reason why they shouldn't make them customizable. - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, November 19, 2000 12:07 PM Subject: Re: clientVar storage/multiple CFAS/single storage db The problem (if there is one) is that the next (or last, I don't know which) value of CFID is kept in the Registry. Two machines that don't talk to one another means both machines *could* come up with the same CFID. Even if possible, it must be very unlikely (ordinarily). OTOH, if you start out with 2 machines, each with a new install of CF, they BOTH start out with CFID=1 at the same time ;-) In addition, in one cookie-less app I've developed, I see that CFAS increments the Register-based current value of CFID with each page request. So while my app might have CFID=56321 with each page request in one instance of the app, if I start another instance of the app it might have CFID=56402 (with the app not accessed by anyone in the interim). best, paul At 11:59 AM 11/19/00 -0500, you wrote: I presume if it's in the registry or a database, it's not going to assign a pair to anyone that is already existing. Therefore, I don't see how two people could end up with the same pair. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Small companies using CF..=)
Who says only the big guys can host major cf driven traffic? http://www.fanfiction.net is a pure 100% cf site pushing out 18+million cf page views per month (more accurate than just hits which can be 2x the number of actual page views) on only 2 round-robined dual-pentium3 800 servers with cheap run-of-the-mill IDE hard drives running W2K and SQL 2000. It's time for the "little" guys to claim our rights to the cf traffic turf and I would like to see what the total of us "little" guys compared to the giants to be honest. =) I see the big company representing for good overall publicity but have to say that it's really the little guys that technically demonstrate that cf aren't all that slow as many claims by squeezing the last bit of juice out of the codes. Large companies can always pop another node into their cf-cluster but most medium and small places can't. Xing ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Netscape 6 and StyleSheets
Although not CF related many of us use stylesheets everyday so I thought
this might save some of you headaches come support time.
Netscape 6 is case sensitve when it comes to style class declarations and
usage. Netscape 4.7 and IE are not case sensitive when it comes to style
class names.
For a dummy text class of:
.TextBlack {text-decoration: none}
span class="TextBlack"Blah/span will work in Netscape 6 and
span class="textblack"Blah/span will not.
I was in shock when Netscape 6 killed my homepage before I found out what's
really going on.
Xing
~~
Structure your ColdFusion code with Fusebox. Get the official book at
https://secure.houseoffusion.com
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Client Data Corruption Under Load?
Just recently people have been logging in but then inadvertantly with other user's account. Basically, if you attempt to login as "joe" you might instead be recognized as "david" once you have passed the authentication. All user verification are through client variables. I have yet to reproduce this on my own but the reports have been so frequent I can no longer discount this as chance. Has any of you experienced a similar problem? Setup: W2K Advanced Server with CF 4.5.1SP1 and SQL 2000 as the backend. This is a pretty serious problem on my end and I would appreciate any help. Xing Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: cfexecute
Make sure the "ColdFusion Application Server" service has the priviledges to access the network drive. By default the services is logged on with "local system" account. Xing - Original Message - From: "Tom Langer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, October 29, 2000 1:20 PM Subject: cfexecuteo I'm having some sort of problem using CFEXECUTE The server is Windows 2000, CF 4.5.1 This works cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip d:\mylittlepdfdocument.pdf" /cfexecute This doesn't work.. cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf" /cfexecute * OR * cfexecute timeout=30 name="d:\pkzip25.exe" arguments="-add -rec -dir=relative d:\temp.zip \\myserver\myshare\mylittlepdfdocument.pdf /cfexecute The E: drive is a mapped network drive going from one machine to another... If I call the following line from the web servers command prompt, it executes ok... d:\pkzip25.exe -add -rec -dir=relative d:\temp.zip e:\mylittlepdfdocument.pdf But it seems that CF doesn't like going across servers or something using cfexecute - please help :-) thx Tom -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: cflocking.. -- ATTENTION -- MY CASE STUDY
I totally agree with you Al. The final judgement should be on our shoulders. Give us the extra option and we will know which will be the best strategy for our unique situations. Even though I love speed, I would take stability any day. I don't mind a few a few milliseconds here and there but I do mind coming in to the server room on a weekend because the coldfusion service has stopped responding again. =) Adding cflocks aren't that bad at all but I would still like the option. I think allaire should concentrate on stability a little more to be honest. Xing From: "Al Musella, DPM" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sat, 16 Sep 2000 20:57:26 -0400 To: [EMAIL PROTECTED] Subject: RE: cflocking.. -- ATTENTION -- MY CASE STUDY I read that paper, and still would like to have an option for automatic locking. Maybe add an attribute to the cfapplication tag: automatic locking: on |off The development time saved on it will more than offset the cost of a faster processor needed for the 2 or 3 microseconds added to each template that will be wasted:) And if you have a transaction problem or a performance problem, you can do it manually. The best of both worlds. I think this one issue is what made Turbobasic and quickbasic such a hit in the 80s and early 90s and VB now. You didn't have to worry about nit picky little things that could crash your program, but which would be easily automated. Developers were free to just worry about the logic. Do you agree with Allaire's reasoning? (By the way - I am a big fan of CF from way back in the 2.0 years.. Al Musella a1webs.com Yes, they explained why. See Allaire's recent paper, "ColdFusion Locking Best Practices" http://www.allaire.com/handlers/index.cfm?ID=17318Method=Full best, paul At 11:56 AM 9/16/00 -0400, you wrote: Why can't cold fusion just automatically lock them? Has Allaire ever responded on this issue? - - -- 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. -- 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.
Dreaded Location: 25 error
I know this has been touched on before but I forgot what the general agreement was on this topic. Can someone refresh me on this? Thanks in advance. For me, this error is directly attributed to volume. After a few days of heavy heavy volume, the servers goes cold with Location: 25. This is pretty "normal" for me and I would love to get rid of this. I have had this problem since 4.0 and on both NT and W2K (4.5.1 on W2K). Xing -- 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.
Re: Upload and retrieval of stories?
Steve Katz, You might want to check out www.fanfiction.net for pointers. Archiving/Publishing of stories from lesser known authors is exactly what we do there. The stories are uploaded by the user and the content, no matter how large, is stored into MS SQL 2000b2 database. You can save and serve the stories out of physical files but I have found out that it is much more efficient to serve them straight from the db. Reading straight from a file and pushing that file to the web is general faster than a db solution on a small scale. However, once you have tons of traffic and thus tons of file i/o calls, the cpu spikes like crazy and everything slows down. The database, although slower under low load, is much more optimized for heavy constant reads and not to mention a internal caching mechanism. Xing www.fanfiction.net - Original Message - From: Steven Katz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 4:00 PM Subject: Upload and retrieval of stories? Hi all, I'm developing a site that will feature short- to medium-length stories from lesser-known authors. I have designed a page that will serve as a template, into which I will insert the material contributed from the authors. I would rather that this process of inserting content not be a manual one. In fact, I would like the programmatic solution to include a web-based administrative interface. Normally, this might consist of some forms and CF or PHP, allowing the user to upload content to a database, where the material could then also be made available to the templates for the dynamic creation of pages. However, form fields seem to have a rather small character limit, preventing one from simply pasting an entire story into them. This isn't really what I want to do anyway. Has anyone devised a good process for accomplishing something similar? Perhaps there's no reason to store this material in a database, anyway? I'd be very interested to hear your suggestions. Thanks, Steven -- 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. -- 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. -- 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.
Re: Upload and retrieval of stories?
Are you saying that if you take the broader perspective, that using a db instead of files is the most efficient way to serve content, any content? I don't believe db based solution is the way to go to server every type of content. In my case, this is true. The site pushes out text content in the averge range of 30KB per pop. Before, I used CF to read in files to a variable and the outputting that to the browser so basically I had CF as the bridge between the browser and file. So instead of having CF accessing the file system i/o directly I have asked CF to access the db instead. I do not have any performance numbers for you but the improvement is significant but this will only help you if you plan to do tons and tons of file reads. So basically the I have changes the previous path of : Browser Web Server ColdFusion File System to Browser Web Server ColdFusion Database If you are serving images then the fastest way to do it is stil lthe old fashioned way of : Browser Web Server File System All the new webservers are have their own caching mechanism you don't have the overhead of coldfusion,asp, or anyother tool pushing the content fromt he database to the webserver. In my experience, and since I have to do everything through ColdFusion, ColdFusion SQL is more efficient than ColdFusion File System in the long haul. However If you can skip coldfusion, skip it. No matter how fast your machine is, having the webserver caching large files is gotta to be faster than cf or sql caching/pushing out large files. Xing If this logic is valid, wouldn't the same be true for serving images, pdf files, sound files, etc? From an application design standpoint, it is a lot cleaner to store everything in the db because: you get all the good things discipline of a db you avoid all the problems screwing around with the OS's file system So, in an ideal world, all content would be in the database. For example, I have heard thgat storing images (or any blobs) in a db will bring it to its knees. I have experimented a little with smaller images and not experienced any problems other than CF 4.0's inability to manipulate binary data. I use ASP to binary read an image, and store it in the db (never storing/renaming/deleting anything in the file system). Then a small ASP program is used to retrieve serve the images when requested in an img tag. Are you saying that if you take the broader perspective, that using a db instead of files is the most efficient way to serve content, any content? Stands to reason that saving/retrieving a few sectors in a db is a lot more efficient than going through all the overhead of allocating/opening a file, etc, then saving/retrieving a few sectors in the file Hmmm... this is very important. Got any performance stats? I'll looked at the fanfiction site... interesting Dick At 2:17 AM + 9/21/09, Xing Li wrote: Steve Katz, You might want to check out www.fanfiction.net for pointers. Archiving/Publishing of stories from lesser known authors is exactly what we do there. The stories are uploaded by the user and the content, no matter how large, is stored into MS SQL 2000b2 database. You can save and serve the stories out of physical files but I have found out that it is much more efficient to serve them straight from the db. Reading straight from a file and pushing that file to the web is general faster than a db solution on a small scale. However, once you have tons of traffic and thus tons of file i/o calls, the cpu spikes like crazy and everything slows down. The database, although slower under low load, is much more optimized for heavy constant reads and not to mention a internal caching mechanism. Xing www.fanfiction.net - Original Message - From: Steven Katz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 4:00 PM Subject: Upload and retrieval of stories? Hi all, I'm developing a site that will feature short- to medium-length stories from lesser-known authors. I have designed a page that will serve as a template, into which I will insert the material contributed from the authors. I would rather that this process of inserting content not be a manual one. In fact, I would like the programmatic solution to include a web-based administrative interface. Normally, this might consist of some forms and CF or PHP, allowing the user to upload content to a database, where the material could then also be made available to the templates for the dynamic creation of pages. However, form fields seem to have a rather small character limit, preventing one from simply pasting an entire story into them. This isn't really what I want to do anyway. Has anyone devised a good process for accomplishing something similar? Perhaps there's no reason to store this material in a database, anyway? I'd be very interested to hear your suggestions. Thanks
Re: Upload and retrieval of stories?
If you want to break up the stories into multiple pages I would suggest breaking them up at the database level and don't store everything in one field. You currently have one table which holds all the contents of the stories uploaded. If you want to have a paging scheme its probably better to go with a two table schem. Stories Table: StoryID, TimeOfUpload, etc. StoriesTextTable: StoryID, StoryTextID, Chapter, ChapterContent. This way you have unlimited number of chapters per story and generally will save you a lot of headache down the road. You can probably do it with one db but better make it scale now than later. Also, you might be interested in AppletFile by www.infomentum.com or just go to www.appletfile.com. It's a great little java applet which can upload files and even give you a progress bar of the current upload status. Just download the demo and if you don't mind the "Trial Softmare" message, you can just use it for your backend admin needs. Xing www.fanfiction.net Thanks for all of the help I've received. It sounds like storing everything in the database might be the best option here. The database I will most likely use is MySQL. If I choose not to build a web-based administrative interface at this stage, what are my other options for uploading the data? Are there any good visual administrative tools? Also, if the entire story is contained within a single field of a record, how can I break it up into multiple pages, such as after a certain number of words? Steven -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 14, 2000 5:06 PM To: [EMAIL PROTECTED] Subject: RE: Upload and retrieval of stories? There are a multitude of ways to do this sort of thing. I'll list a couple to get you thinking and then, if you have further questions, elaborate, as I'm sure others will as well. 1) Use form fields. The author would have to enter his story via the form, manually. 2) Use form fields. The author could enter descriptors such as title, keywords, etc. But have the body of the story uploaded via a "file" form field. Unless you have, or will build, conversion capabilities I would have the bodies uploaded as ASCII text files. For some document file types conversion is trivial while others are more difficult. 3) Upload all information as an XML document. This can be facilitated using WDDX. You could use either of the above methods with this or just send a single document. In example #1 you would convert to WDDX either at the client, via JavaScript/WDDX functions, or at the server. Example #2 would work in much the same way except you would probably want to do the conversion to ASCII text, if necessary, before encapsulating everything in XML/WDDX. If everything is sent as a single WDDX document, via a file upload (HTTP or FTP), you can either store it in the database or as a file. I haven't tried this, pipe in anybody, but, depending on your database, you may be able to query the XML data. I don't mean just pull the record, I mean use SQL queries that actually search on the XML entities within the record. I know that Oracle and MS SQL Server can do this to some degree but, I'm not sure that it will work with WDDX. Using a database is going to be extremely more effective and efficient than a file based system. Querying a file structure is an I/O intensive operation. Databases are meant for this sort of thing, so I'd use one. Once you've made your template you can easily query the database for stories and dynamically insert the content into the template for display at the client. I hope this gives you some ideas. I'm sure there are many other ways of doing this but, these came to mind first. There are a lot of great people on this list so you'll be good to go. Steve -Original Message- From: Steven Katz [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 14, 2000 7:00 PM To: [EMAIL PROTECTED] Subject: Upload and retrieval of stories? Hi all, I'm developing a site that will feature short- to medium-length stories from lesser-known authors. I have designed a page that will serve as a template, into which I will insert the material contributed from the authors. I would rather that this process of inserting content not be a manual one. In fact, I would like the programmatic solution to include a web-based administrative interface. Normally, this might consist of some forms and CF or PHP, allowing the user to upload content to a database, where the material could then also be made available to the templates for the dynamic creation of pages. However, form fields seem to have a rather small character limit, preventing one from simply pasting an entire story into them. This isn't really what I want to do anyway. Has anyone devised a good process for accomplishing something similar? Perhaps there's no reason to store this material in a database,
Re: Upload and retrieval of stories?
But, then, why doesn't it, also, make sense to use static html pages (processed and cached by the web server) and avoid CF SQL altogether. I agree. The best, fastest, and most scaleable way to push pages is to push pre-generated "static" pages as much as possible. I personally would love to cache everything in the database and have a dedicated server which pumps out new versions every 30 minutes or so. But a lot of the sites now a days are so dynamic it's not possible to skip the cf or sql all together. What I like to do is cache the slowest and not frequently modified part of a site to the database and update the content every 30 minutes. This may change in the future as we may want to programatically manipulate non=text content before presentation. If there is a need to maintain a large repository of digital (non-text) content then a database appears to offer some significant advantages for: accessing, cataloging, security, referential integrity, backup... As the web evolves, we may need to change the way we think about non-text content... In a couple of years I bet almost everything and anything will be dynamic. With XML climbing the ladder as of late I could see a reduction of binary files. I could see the entire web site delivered as XML text in compressed form and everything including the images will be described in a format similar to SVG. Even now, with SVG, we can use any application server to pump out vector graphics with the vistor's name customized below the site logo. On the subject of text, I believe all major browsers has an internal gzip decompressor with can deflate the compressed html stream from a web server. Which webservers compresses the outgoing streams? Is there an option in IIS that we can set or is this automatic? I'm just curious and would love to save some bandwith. ... what, with applets, embeds, images,etc - what percentage of the typical page (at the browser client) is actually text? Apple's new OSX uses Quartz for presentation services... this mean that everything you see on the screen is in PDF format. (See below). Does this mean that we could serve PDF pages directly to a Mac Client and eliminate all plug-ins browser overhead, extra OS Presentation overhead... probably! Couldn't the same approach apply to images, audio, video... probably! Didn't Apple go with the PDF approach because the PostScript licensing was too mcuh? There was this big discussion at the mac site a while back regarding this. Supposedly PDF can't handle remote imaging but PostScript can. It's been a while so I can be totally wrong in this. I would have bought OS X beta if it had support for Airport. But yeah, that would be a dream of every web developer: having total and constant control of the client/server connection/interaction. Now you have got me dreaming. =) In a few years. Xing -- 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.
Re: Debugging an undefined DB
You might be experiencing the "comment" bug in your code. If you did not complete the cf comment tags, nothing below the faulty comment tag will be executed. It has happend to me quite a few time. =) Xing From: Gene Kraybill [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 15 Sep 2000 22:55:10 -0700 To: [EMAIL PROTECTED] Subject: Debugging an undefined DB Why doesn't an attempt to access an undefined DB produce a CF error? Just spent too much time trying to figure out why pages on a db-driven site weren't displayingNo errors, no content, just the standard CGI variables, etc. at the bottom... It seemed to be a CFSETTING ENABLECFOUTPUTONLY problem, but eventually I remembered I hadn't defined the DSN after re-installing CF in the wake of a hard drive rebuild...Worked perfect once I redefined the DSN g... The odd thing was that even tho I have all CF debugging turned ON, my pages came up without any CF errors... Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net -- 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. -- 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.
CF 5.0 and misc questions...
Anyone here knows the timetable for CF 5.0? As for the pharoh engine, is it going to compile CFML straight to java bytecode or it it gonna translate it to JSP as show in the tech roadmap pdf? On to misc questions. =) 1) Has anyone gotten or know the meaning behind "Pure virtual function call exception error" on CF 4.5.1 with W2K? A window pops up with that error and CF continues to function. however, if you click on ok on the pop-up windows box, cf services stops. Very very weird. 2) Another weird thing and has to do with the CFFILE i/o interaction. CFFILE is throwing errors when it shouldn't be. This happens when CFFILE is accessing a folder with file count larger than approx. 13800 files. The file system is FAT32 running on W2K Advanced Server. I'm baffled by these errors and would love to know the timeline for CF 5.0 which will finally allow us to make 24/7 programs and not have to wait for cfschedule or someone hitting the server for it to run tasks. I'm pretty excited. =) Xing -- 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.
Re: SQL or PHP with CF for this problem?
Britta, I don't think PHP or mySQL would help your situation since the problem is strictly database related and mySQL does not support nested queries which is helpful at times. TO ADD A NEW PRODUCT from "new" to "Products2" if not already listed in "Products2": INSERT INTO Products2 (ProductID, Product, UnitPrice) SELECT ProductID, Product, UnitPrice FROM new WHERE new.Product Products2.Product (but this creates huge amounts of duplicates. I need the product just = to be added once.) Try this: INSERT INTO Products2 (ProductID, Product, UnitPrice) SELECT ProductID, Product, UnitPrice FROM new WHERE ProductID NOT IN (SELECT ProductID FROM Products2) This will get all all the products NOT IN the Products2 table. Update price of existing product: UPDATE Products2 (UnitPrice) SET UnitPrice=3D(SELECT UnitPrice FROM new) WHERE new.Product=3DProducts2.Product (I want to update those records in Products2 that have a different = UnitPrice "SELECT UnitPrice FROM new" will get ALL the prices from that table and that's not what you want. You only want to return the record for that specific ProductID (WHERE New.ProductID = Products2.ProductID). UPDATE Products2 SET UnitPrice= (SELECT UnitPrice FROM new WHERE New.ProductID = Products2.ProductID) WHERE new.ProductID = Products2.ProductID AND New.Price Products2.Price Xing -- Archives: http://www.eGroups.com/list/cf-talk 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.
Re: how to separate 400 query resutls into 20 pages?
Ins, I would recommend Ben Forta's CF books since he has a very clear section on how to implement that. In the simplist form, you have something like this: CFPARAM Name="Url.Page" default="1" CFPARAM Name="Variables.MaxPerPage" default="50" CFQUERY Name="myData" CFLOOP Quey="myData" startRow="#Evaluate(Url.Page * MaxPerPage - MaxPerPage + 1)#" endrow="#Evaluate(Url.Page * MaxPerPage)#" /CFLOOP All you need to pass in is the incremented page counter (Url.Page) and calculate the offsets depending on how many records you want per page. StartRow and EndRow attributes do work and they work rather well. However, if you have a query that returns something huge, like 10,000 records, I would suggest caching and segementing the query by caching the page boundries. Xing Hi, I have a query which returns 431 results: cfquery name="qGetCompany" select companyname from company where countrycode='au' /cfquery I want to separate these results into many pages, each page contains 20 results and have links to each page, if the current result is on page 4 ,should have this : page1, 2, 3,prev, 4.. next 6, 7 ...20... startrow endrow don't work:(resuilts are not from continueing row numbers in the table) cfloop query="qGetCompany" startrow="#starrowthispage#" endrow="#endrowthispage#" -- Archives: http://www.eGroups.com/list/cf-talk 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.
CF and MS Index server?
I'm curious. Is it possible to use the built-in indexing engine bundled with IIS and then access/search through the stored data via some CF recognizable interface? COM? Soemthing other than CFCOLLECTION is what I'm trying to get at... Xing -- Archives: http://www.eGroups.com/list/cf-talk 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.
Help with broken CLIENT storage and CFADMIN area
I have a VERY annonying problem on my hands. ME: 1) In the CF admin, set an odbc db to use as CLIENT storage. 2) Everything works fine. Good. 3) After a week or two: hey, I don't need CLIENT storage! 4) Go in to CF Admin and remove the db as CLIENT storage. CF ADMIN: 5) Bam! "Error Diagnostic Information Invalid client variable storage specified. The name you specified, 'DBFANFICTION', has not been enabled as client variable storage." I did not realize cf admin area used client storage. Moreover, I expected better error handling of this on the part of Allaire. As of now, the cf administration area is inaccessible as result of the above error and I have no clue how do go around this WITHOUT having to reinstall CF 4.5.1. Any help would be much appreciated. Xing -- Archives: http://www.eGroups.com/list/cf-talk 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.
Re: Macs, PC's, and Cold Fusion
Joel, There is an undocumentated bug with Mac IE in conjunction with CF's cflocation tag. I have found the problem to only exist when you are submitting a form and attemp to cflocate after some action. It does not happen with all forms but only the critical ones you need to have working by some deadline. ;-) In almost all cases when this happens, the script IS executed properly. The Mac IE browser just chokes on the http redirection headers. I haven't isolated the bug and that's the extent to what I can give you in terms of info. Good luck! Xing p.s. Macs rule! Does anyone have problems with pages working differently from PC to Mac? I'm having problems with a site I did. All the pages do is simply perform and addition or update to the database. In IE and Netscape on the PC, it works fine. It pops up an alert box and redirects. On the Mac, when the form is submitted, it just prints a blank html page. It never writes the data, or redirects. It does nothing. Can anyone help me figure this out? I'm losing more and more hair and brain cells. It's IE 4.5, if that helps. I don't wanna bash Macs, but... Thanks. === Joel Firestone - Developer Delmarva Online http://www.dmv.com/ -- Archives: http://www.eGroups.com/list/cf-talk 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. -- Archives: http://www.eGroups.com/list/cf-talk 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.
Re: Preventing file download.
Guy,
Move the CAD files out of the web folder and use CFCONTENT to push the cad
files. The CFCONTENT script will be programmed to accept and validate an
encrypted phrase passed by the calling file (applet).
Now here is the worse part. The key used to validate and encode (CFENCRYPT)
the phrase must change everytime you push any CAD file. This means that the
second your java applet downloads the cad file, the encrypted phrase will be
out-dated and invalid for later use.
One way to do this is to store the key for each use in a Session. variable.
On applet code generating script:
applet
parameter cadfile="secureCADpush.cfm?password=#cfencrypt("Make it
work",Session.DynamicKey)#"
/applet
On push script:
!--- make sure the decryption works ---
CFTRY
CFIF cfdecrypt(url.Password, Session.DynamicKey) EQ "Make it work"
!--- create a new key and invalidate all previous encrypted phrases
---
CFSET Session.DynamicKey = Now()
!--- push file ---
CFCONTENT
/CFIF
!--- output error or do nothing ---
CFCATCH Type="ANY"
PUSH denied.
/CFCATCH
/CFTRY
I think this should work. However, the user might be smart enough to figure
out the scheme and stop the web browser right before the java code is
executed. Thus, the push never happens and by looking at the source code and
grabbing the url, the person will be able to download the file.
The java applet is execute on the client side so there is now way to
distinguish the applet request for the file as compared to the browser
request. Or is there? Not sure about this.
You can also beef up the security by only allowing cfcontent push when
HTTP_REFERER exists and that the domain is from your site.
Xing
fanfiction.net
Building an application that uses a cad file viewer that is a java applet.
The viewer loads a cad file from the document root on the web server and
display it in a browser.
The problem I have is that a user can view the source for the web page, get
the URL to the cad file and download the cad file to his local system.
I am looking for a way to allow the viewer to see the cad file but prevent a
user from downloading it. I am thinking that a component sitting in the
document root of the web server that could relay the file to the java
applet. Anyone found a solution for this or have any ideas?
TIA
Guy
--
Archives: http://www.eGroups.com/list/cf-talk
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.
--
Archives: http://www.eGroups.com/list/cf-talk
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.
Re: cftransaction and cfserver 4.5.1 MY MISTAKE...
Are you sure the "cut-off" error message is not the result of broken html code as result of the abrupt stoppage of the content generation? I get those a lot and especially on pages with nested tables. View the html source to see if the error is there. Xing HOWEVER... the problem of not being able to read the error message still remains ... has anyone else seen this?? it happens a bit. i have the debugging sent to the ip address 127.0.0.1, and it only happens sometimes sorry for the previous post... -- Archives: http://www.eGroups.com/list/cf-talk 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.
RE: Security holes revisited -- reward offered
Wrap CFTRY and CFCATCH Type="ANY" around your CF applications so he can't view partial "source code" through error messages. Not a physical bug but I think it can lead to more serious intrusions. Xing Ok, fellow Listees, here's the deal... My boss's daughter has a boyfriend.. (can you smell the trouble already???). He is bent out of shape over the fact that I did not recommend that we hire him (I interviewed him and gave his skill sets an honest, thorough exam). He is good at A/V stuff, but his web experience/database experience is null. Anyway, back to the situation.. He has convinced the boss to pay him 2 grand to attempt to hack the system I built. He claims to be a super hacker, blah, blah, blah. I am not too confident that he can do it, but there is a small chance Multiple minds are better than one. I have gone over and over all the stuff I know, but I am more than likely missing some stuff. Anyone care to share their CF/NT/IIS security checklist or other advice? It's escalated into all-out war. He is going to stop at nothing to make me look bad, and I will stop at nothing to prevent him from succeeding. Thanks in advance. I will custom print 5 free T-shirts with your logo (in one color) on them if you give me advice that plugs up a hole that I didn't know about. Thanks in advance. Nick Call [EMAIL PROTECTED] http://www.graphixonline.com -- Archives: http://www.eGroups.com/list/cf-talk 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.
Re: Help refresh in frame
I think this might work. If you want to use a link to refresh the page but fear the browser might cache the individual pages try the following: Append and pass a bogus url variable containing a unique value to all the frames in your frameset. myframeset.cfm?bogusvar=#UUID()# You will never get the same value returned from the UUID() function. Good for creating absolute unique values. Pretty sure that the browser uses url variable to determine and retrieve the cache file. If the value is always different, it has to create a new cache. Xing Hi, Does anyone know how to completely clear the cache and refresh frame without clicking on the refresh function on the browser? I use 3 meta tags on those pages and it doesn't seem to work. META HTTP-EQUIV="Expires" CONTENT="0" META HTTP-EQUIV="Pragma" CONTENT="no-cache" META HTTP-EQUIV="Cache-Control" CONTENT="no-cache" Cecilia M. Lam Ektron, Inc. www.ektron.com [EMAIL PROTECTED] (603)594-2350 x 211 -- Archives: http://www.eGroups.com/list/cf-talk 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.
