Paging Principals
Hi, I have an app that queries a table and displays a subset of the query results in a paged format, showing only 10 results per page. Some queries will return upwards of 1,000 rows. This query joins quite a few tables - say 8 or so, however the query itself only requires one table to obtain the basis of the dataset(the rest of the tables in the join are used for display info or 'cosmetic' type information). Generally speaking, which of the following would be more efficient: Option 1: - Query database, joining 8 tables, get entire dataset (1000 rows) - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) Option 2: - Query database only based on the results of one table (1000 rows) - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) - within output loop, perform second query joining the 8 tables, based on a single primary key returned from the initial dataset. (returns single row) In essence, the question revolves around whether it is more expensive to pull an entire 1,000 record joined dataset in one shot, or to make the initial query lean, and then do ten consecutive queries performing the join. The former likely incurs more database load, while the latter would incur more interaction with odbc. Whew. Interested in your answers! Thanks, Geoffrey Brown Online Operations Manager Deerfield.com 989.732.8856 ext. 227 (Gaylord) 231.935.4640 ext. 123 (Traverse City) [EMAIL PROTECTED] http://www.deerfield.com Personal Service with a :-) VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Paging Principals
Hi, Good idea. A cached query wouldn't work for us, unfortunately, as the data changes almost by the minute. Geoff B -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 9:43 AM To: CF-Talk Subject: RE: Paging Principals When I had something like this, I used the full query but only retrieved the top n, where n is the highest index to display. So, if you are displaying 10 per page... page 1, n=10 page 2, n=20 and so on. Maybe not a perfect solution, but dropped average processing time a lot, since people would generally either narrow the search or only look at the first page or two. If you think people might be flipping through a large number of pages, look at query caching. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 9:18 AM : To: CF-Talk : Subject: Paging Principals : : : Hi, : I have an app that queries a table and displays a subset of the query : results in a paged format, showing only 10 results per page. Some queries : will return upwards of 1,000 rows. : : This query joins quite a few tables - say 8 or so, however the : query itself : only requires one table to obtain the basis of the dataset(the rest of the : tables in the join are used for display info or 'cosmetic' type : information). : : Generally speaking, which of the following would be more efficient: : : Option 1: : - Query database, joining 8 tables, get entire dataset (1000 rows) : - CFOUTPUT / Loop limited to start row (page ordinal) and maxrows (10) : : Option 2: : - Query database only based on the results of one table (1000 rows) : - Cfoutput / Loop limited to start row (page ordinal) and maxrows (10) : - within output loop, perform second query joining the 8 tables, : based on a : single primary key returned from the initial dataset. (returns single row) : : In essence, the question revolves around whether it is more expensive to : pull an entire 1,000 record joined dataset in one shot, or to make the : initial query lean, and then do ten consecutive queries : performing the join. : The former likely incurs more database load, while the latter would incur : more interaction with odbc. : : Whew. Interested in your answers! : : Thanks, : Geoffrey Brown : : Online Operations Manager : Deerfield.com : 989.732.8856 ext. 227 (Gaylord) : 231.935.4640 ext. 123 (Traverse City) : [EMAIL PROTECTED] : : http://www.deerfield.com : Personal Service with a :-) : : VisNetic (viz-net-ik) 2002: vision of the Internet http://www.visnetic.com : : ~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Paging Principals
Hi, This wouldn't sound not too different than a stored procedure then. It is written in a pretty solid stored procedure at present. Geoff B -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 2:25 PM To: CF-Talk Subject: RE: Paging Principals I can't speak for Oracle, but in MS SQL you get some limited performance gains, because the DB does the statement optimization once, then stores it. Not a huge gain, to be sure, but some. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Andre Turrettini [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 2:14 PM : To: CF-Talk : Subject: RE: Paging Principals : : : My understanding of a view is that it is recreated when you run : your query. : At least in Oracle it does the joins under the hood at the time : you request : your data. Thus, there should be no performance gains there. : : DRE : : -Original Message- : From: Mark Stewart [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 11:53 AM : To: CF-Talk : Subject: RE: Paging Principals : : : You need to be careful with this scenario because it may not be more : efficient, it depends upon your database schema. I tried this on an : application we were doing and our situation was that it was possible to : bring back 200 - 300k records (not likely, but possible). Our database was : created in such a way that even though we tried bringing back the top n : records, the query still had to touch every record in all the joined : tables. The result was minimal to no performance increase. The : moral of the : story would be, it largely depends on your indexing and schema whether a : particular technique will work or not. : : A view, as Jon mentioned, would be a very good idea since you : wouldn't have : all the joins involved. The only thing you need to worry about with a view : is the inserting and updating on the underlying tables and what the : performance hit will be on back-end processing updating the view, : especially : if you're relying on CF to do the inserting and updating. : : Mark : : : -Original Message- : From: jon hall [mailto:[EMAIL PROTECTED] : Sent: Wednesday, September 10, 2003 12:57 PM : To: CF-Talk : Subject: Re: Paging Principals : : : Since most people are not going to browse through all 100 pages of : records, pulling a 1000 records for everyone, has some obvious : inefficiencies. : : I'd go for individual queries on each page, but take the 8 join query : out of CF, and make it a view. The view will help lessen the impact of : that query, and make your code less complex at the same time. : : -- : jon : mailto:[EMAIL PROTECTED] : : Wednesday, September 10, 2003, 9:17:43 AM, you wrote: : GVB Hi, : GVB I have an app that queries a table and displays a subset of the query : GVB results in a paged format, showing only 10 results per page. Some : queries : GVB will return upwards of 1,000 rows. : : GVB This query joins quite a few tables - say 8 or so, however the query : itself : GVB only requires one table to obtain the basis of the : dataset(the rest of : the : GVB tables in the join are used for display info or 'cosmetic' type : GVB information). : : GVB Generally speaking, which of the following would be more efficient: : : GVB Option 1: : GVB - Query database, joining 8 tables, get entire dataset (1000 rows) : GVB - CFOUTPUT / Loop limited to start row (page ordinal) and : maxrows (10) : : GVB Option 2: : GVB - Query database only based on the results of one table (1000 rows) : GVB - Cfoutput / Loop limited to start row (page ordinal) and : maxrows (10) : GVB - within output loop, perform second query joining the 8 : tables, based : on a : GVB single primary key returned from the initial dataset. (returns single : row) : : GVB In essence, the question revolves around whether it is more expensive : to : GVB pull an entire 1,000 record joined dataset in one shot, or : to make the : GVB initial query lean, and then do ten consecutive queries : performing the : join. : GVB The former likely incurs more database load, while the latter would : incur : GVB more interaction with odbc. : : GVB Whew. Interested in your answers! : : GVB Thanks, : GVB Geoffrey Brown : GVB : GVB Online Operations Manager : GVB Deerfield.com : GVB 989.732.8856 ext. 227 (Gaylord) : GVB 231.935.4640 ext. 123 (Traverse City) : GVB [EMAIL PROTECTED] : : GVB http://www.deerfield.com : GVB Personal Service with a :-) : : GVB VisNetic (viz-net-ik) 2002: vision of the Internet : http://www.visnetic.com : : GVB : : : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
RE: Image manipulation
Hi, Efflare has a great solution, though, it is pricey, as you state. It is rock solid, and we put ours under very heavy load. Geoff B -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 2:58 PM To: CF-Talk Subject: Image manipulation Hi, all. Ok...my head hurts from searching...I've checked the archives... Just can't find the answer I need... Is there any image manipulation tag that will allow the width to be specified and have the height automatically sized so that the image remains proportional? Couldn't find that answer concerning ImageMagick...and Efflare might do it, (haven't checked), but boy, Efflare's costly... Almost all my resizing needs width specified and height automatically calculated proportional to width... Solutions? Thanks, Rick ~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
ODBC Error: Timeout Expired
Hi, We are running SQL Server 7.0. I'm getting "timeout expired" errors on one script, which runs a lenthy query. The CFQuery has a timeout attrib of , and the script has a requesttimeout value of . The error is still occurring. I'm thinking this must be a server config issue. Any ideas on resolution? Geoff B 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]
Win2k Clustering and CF
Hi, I've got a small win2k cluster setup for some CF apps that I'm running. I now need a way to monitor the CF service from a third box on the same network. If CF begins queueing too many requests, or is not responsive, I need to remove the box from the cluster. Removing the box can be done very easily, however, monitoring the CF service has proved to be elusive. Is there a third party tool available for monitoring the CF service in a cluster or otherwise? Thanks, Geoffrey Vail Brown __ Director of Online Operations Deerfield.com 231.935.4640 [EMAIL PROTECTED] Check out our complete line of Internet leveraging software at: http://www.deerfield.com -- 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.
Sharing sessions between CFM ASP
Hi, I have a session var that needs to be shared between a CFM script and an ASP script on the same server (same domain, etc). Is this possible? How? - Geoff B -- 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: Javascript string search question...
Hi, You can use this: MyString.indexOf("substring") This will return -1 if not found, or a value if the substring is found. - Geoff B -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 2:17 PM To: CF-Talk Subject: Javascript string search question... Anyone know how to do a text string search in Javascript? I've used substring before, but I'm looking for some way to do something akin to find() in CF, where it finds the substring ANYWHERE in the string to be searched. Is it necessary to do a character by character search, or is there a javascript command to find any instance of the search string in the string to be searched? CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Stewart, Mark [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 12:44 PM To: CF-Talk Subject: RE: CFServer a memory leaker? Tim, I'm basically running the same thing: Win98, CFServer, CFStudio, PWS, Intel Celeron 300 (overclocked to 450) and 128 RAM. I've had a few problems, but nothing major. This configuration works quite well for what I use it for. Now, I wouldn't use this for any type of production scenario, but it works well for just playing around at home. I also run many other programs on this machine as well: MS Office, numerous games, mem turbo and Zone Alarm. I would definitely beef-up the RAM on your machine and it should act a little better. For what it's worth, ~Mark -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 11:54 AM To: CF-Talk Subject: CFServer a memory leaker? At home I have installed CFSERVER running on Personal Web Server, using RDS. Since I have installed both server and studio, my system is very unstable and totally locks up many times a day. This is on Windows 98 with only 64 meg of RAM. Is this simply a memory issue, or is this configuration giving everyone else fits as well??? Tim Claremont Xerox Corporation -- -- -- 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. -- 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: Sharing sessions between CFM ASP
How about cookies, this would even be workable in the situation? -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 3:31 PM To: CF-Talk Subject: Re: Sharing sessions between CFM ASP Not really possible. You can however, send a variable between pages (links, cfhttp, etc.) and convert the variable (form, url) into that application server's session variables. It works just like passing session variables between 2 ColdFusion servers. -- Billy Cravens [EMAIL PROTECTED] "Geoffrey V. Brown" wrote: Hi, I have a session var that needs to be shared between a CFM script and an ASP script on the same server (same domain, etc). Is this possible? How? - Geoff B -- 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: ASP or Coldfusion?
Here's a question- are you running 4.0 or 4.5.x? -Original Message- From: Richard Fantini [mailto:[EMAIL PROTECTED]] Sent: Friday, September 22, 2000 12:16 PM To: CF-Talk Subject: Re: ASP or Coldfusion? Then you truly must be doing something wrong... Our main site does over 1.2 million hits a week with extremely heavy database and CF processing. The CF machine is a Dual PII 400, 512mb RAM and a RAID array... The database hardware is identical, and is running SQL7. That's it, no clustering or anything like that. We rarely ever have a problem with CF. The code has been optimized on the heavily hit pages but there is still a decent amount of older quick and dirty stuff. I don't have a clue as to how you were crashing the server with only 100,000 hits... but I'm willing to bet it was your code. -Rich - Original Message - From: "Geoffrey V. Brown" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 22, 2000 10:45 AM Subject: RE: ASP or Coldfusion? Hi, I'll offer my opinion, as I'm facing the same thing. I have a site that is going to be massive. Cold Fusion simply could not hold up to the load, and crashed repeatedly. The site is about 99% data driven, so there is a lot of data access going on. I am now developing this site in ASP, and it seems far more stable. We are generally getting 100k+ hits a week on this site. After seeing many large projects fail with cold fusion, I'd recommend trying other options before going the CF route on a large project. Note, I am a die hard CF developer, I feel that CF is good for smaller sites, less hits, and allows for a faster development time than ASP... but it just doesn't hold up on larger projects. -- 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: ASP or Coldfusion?
Hi, I'll offer my opinion, as I'm facing the same thing. I have a site that is going to be massive. Cold Fusion simply could not hold up to the load, and crashed repeatedly. The site is about 99% data driven, so there is a lot of data access going on. I am now developing this site in ASP, and it seems far more stable. We are generally getting 100k+ hits a week on this site. After seeing many large projects fail with cold fusion, I'd recommend trying other options before going the CF route on a large project. Note, I am a die hard CF developer, I feel that CF is good for smaller sites, less hits, and allows for a faster development time than ASP... but it just doesn't hold up on larger projects. -Original Message- From: Dean Alexandrou [mailto:[EMAIL PROTECTED]] Sent: Friday, September 22, 2000 10:01 AM To: CF-Talk Subject: ASP or Coldfusion? I am not sure what tool to use to develop quite a major site. I have heard that while coldfusion is good for small sites, ASP is more robust, and would cope better with a large site that has to deal with a few thousand hits a week. -- 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: ASP or Coldfusion?
Hi, We had a Dual P3 600, 1gig+ ram as a cf box, running 4.5.1. The db server was SQL Server 7 on a dual 600, 512 ram. No clustering. We have roughly 70 queries that cache data, 20-40 recordsets each. Some queries use stored procedures, others do not. Each page runs a minimum of three queries. Server settings are as Allaire recommends for multi processor systems. -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: Friday, September 22, 2000 10:51 AM To: CF-Talk Subject: RE: ASP or Coldfusion? I'm curious on this one. What set-up did you have? Where did the issues arise? Did you cluster? CF Server and DB on same machine? Caching strategies? DB Stored Procedures? What server settings? No criticism, just genuinely interested as Allaire has done some analysis which indicates a dual pIII 1/2 Gig server should be able to deal with 500-600 responses every 8 seconds and that clustering servers provides a linear growth. -- From: Geoffrey V. Brown[SMTP:[EMAIL PROTECTED]] Sent: 22 September 2000 15:45 To: CF-Talk Subject:RE: ASP or Coldfusion? Hi, I'll offer my opinion, as I'm facing the same thing. I have a site that is going to be massive. Cold Fusion simply could not hold up to the load, and crashed repeatedly. The site is about 99% data driven, so there is a lot of data access going on. I am now developing this site in ASP, and it seems far more stable. We are generally getting 100k+ hits a week on this site. After seeing many large projects fail with cold fusion, I'd recommend trying other options before going the CF route on a large project. Note, I am a die hard CF developer, I feel that CF is good for smaller sites, less hits, and allows for a faster development time than ASP... but it just doesn't hold up on larger projects. -Original Message- From: Dean Alexandrou [mailto:[EMAIL PROTECTED]] Sent: Friday, September 22, 2000 10:01 AM To: CF-Talk Subject: ASP or Coldfusion? I am not sure what tool to use to develop quite a major site. I have heard that while coldfusion is good for small sites, ASP is more robust, and would cope better with a large site that has to deal with a few thousand hits a week. -- 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. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- 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.
Application in ASP
Hi, Here I am again, defiling the list with another ASP question. Sorry, but it is somewhat CF related Does anyone know if ASP has an application.cfm equivalent? Thanks, Geoff B -- 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.
URGENT! - Help With OLEDB
Hi, With some playing around, I have found that OLEDB seems to be much more stable that ODBC. For awhile, we were recieving random disappearances of ODBC datasources, which required a reboot. Anyway, the problem I'm having is that the results from OLEDB aren't consistant with those in ODBC. Example: I have one query that returns a series of results, and the query is dynamically generated. This works *perfectly* under ODBC. Under OLEDB, it returns zero records. I've tried even moving the query to a stored procedure and generating it dynamically from there. No good. Regardless of what I've tried, simply changing from ODBC to an OLEDB datasource effects the results returned. Any ideas, thoughts, help?!? Thanks, Geoff B -- 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.
CFX in ASP
Hey, I was wondering if anyone knew of anyway to pull data from a CFX using ASP? I'm thinking it could be done in a round-about way, as Cold Fusion is on the same box as the ASP server, but for the sake of stability we need to run some scripts in ASP. Ideas? Thanks, Geoffrey Vail Brown -- 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: Can't work out IIF/IsDefined quirk
Hi, Use this: #IIF(isdefined("form.categories"), "form.categories", de(''))# Thanks, Geoffrey Vail Brown __ Director of Online Operations Deerfield.com 231.935.4640 [EMAIL PROTECTED] Check out our complete line of Internet leveraging software at: http://www.deerfield.com -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 29, 2000 9:20 AM To: Cf-Talk Subject: Can't work out IIF/IsDefined quirk I got this: Error Diagnostic Information An error occurred while evaluating the expression: #IIF(IsDefined("form.categories"), form.categories, DE(''))# Error near line 51, column 11. -- -- Error resolving parameter FORM.CATEGORIES The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. It's supposed to check if it's been defined, and then if it has output it, and if it hasn't, output nothing. IT'S NOT WORKING! Anyone any idea why? Paul -- 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: Can't work out IIF/IsDefined quirk
Hi, Don't mean to disagree, but give that line of code a shot, I use it everywhere in my scripts! You must use double quotes around the variable name though. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 29, 2000 10:26 AM To: [EMAIL PROTECTED] Subject: RE: Can't work out IIF/IsDefined quirk On 8/29/00, Geoffrey V. Brown penned: Hi, Use this: #IIF(isdefined("form.categories"), "form.categories", de(''))# Sorry. You can't use isdefined in an IIF. If it's not defined it will still try and reference the variable and return an error. If you must use isdefined, you'll need to use a real cfif. What you can do is this: CFIF isDefined('form.categories') cfset variables.categories = form.categories cfelse cfset variables.categories = "" /CFIF IIf(variables.categories is "", DE(''), DE(variables.categories))# Or: IIf(variables.categories is "", DE(''), DE('#variables.categories#'))# -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- 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: Why Netscape's serious lag time?
Hi, Netscape is a little freaky about tables. You have to make sure that all of your width / height calculations are defined, and are accurate. On first glance, I found that you have a table with a width of 600 contained within a table with a width of 585. Netscape is probably trying to recalc all the tables, which causes the lag. I didn't dig any deeper than that though... Thanks, Geoffrey Vail Brown __ Director of Online Operations Deerfield.com 231.935.4640 [EMAIL PROTECTED] Check out our complete line of Internet leveraging software at: http://www.deerfield.com -Original Message- From: Harold Goodson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 8:04 AM To: [EMAIL PROTECTED] Subject: Why Netscape's serious lag time? Hey all, Might anyone be able to offer a plausible solution to Netscape's lag time at the following URL? It appears to be loading the tables and *all* of their images before displaying the page at all. This problem exists in other sites I have worked on and I've yet to find a solution outside of not using tables within tables. I can't imagine it being caused by the CF code, but I can't really see what's causing it to happen. http://www.awgear.com/products/index.cfm?fuseaction=dsp_productsD epartment _name=Sleeping%20BagsDepartment_img=sleepingbag_tn_title.gif or just: http://www.awgear.com and click sleeping bags or most all of the links. Any ideas/suggestions would be appreciated. -Andy G. -- 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: Cold Fusion vs. Java Servers: Performance
Hi, I would also be very, very interested in this information... -Original Message- From: Jonathan Fisher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 1:08 PM To: [EMAIL PROTECTED] Subject: Cold Fusion vs. Java Servers: Performance This is a multi-part message in MIME format. --=_NextPart_000_0072_01C00C9E.934BFA50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi guys, has anyone had any experience with any of the popular Java application = servers (Weblogic, Websphere, Silverstream, Bluestone etc)? Or seen any = benchmark results for them? I'm trying to find out how well Cold Fusion = stands up against them from a strictly performance based standpoint - = processing time, stability, amount of load they can handle,etc. What I'm = trying to figure out is if these Java servers have anything in their = favour apart from using a standard non-proprietary programming language. Thanks much, J --=_NextPart_000_0072_01C00C9E.934BFA50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3017.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi guys,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2has anyone had any experience with any = of the=20 popular Java application servers (Weblogic, Websphere, Silverstream, = Bluestone=20 etc)? Or seen any benchmark results for them? I'm trying to find out how = well=20 Cold Fusion stands up against them from a strictly performance based = standpoint=20 - processing time, stability, amount of load they can handle,etc. What = I'm=20 trying to figure out is if these Java servers have anything in their = favour=20 apart from using a standard non-proprietary programming = language./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks much,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2J/FONT/DIV/BODY/HTML --=_NextPart_000_0072_01C00C9E.934BFA50-- _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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: Cold Fusion vs. Java Servers: Performance
Any feedback on JRun performance vs CF? -Original Message- From: Ed Toon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 5:15 PM To: [EMAIL PROTECTED] Subject: RE: Cold Fusion vs. Java Servers: Performance Cold Fusion doesn't stand up to them. At all. I've watched a couple of sites move from CF to ATG Dynamo and WebLogic, and the performance just can't be compared... they knock the socks off of CF. That isn't to say that CF can't be used in high traffic sites - if you want to have a few dozen servers running. I personally love CF for intranets and other low traffic applications, betas, etc.. but it's just not in the same league as those guys. As we move closer to JRun/CF integration it will start to compete though. ;) Ed -- 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.
Let's Brag...
Hi, We're looking to upgrade some of our servers. I saw that one CF load balancing document recommended a certain Compaq server for use with CF. I was wondering, what kind of servers is everyone else running? Just for the sake of my own curiosity Thanks, Geoff B -- 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: Good inexpensive NT Email Solution
Hi, I'd highly recommend MDaemon. Not that I'm biased or anything We do have a CF interface to MDaemon as well, if that is a solution you decide to go with. You can find the trial here: http://mdaemon.deerfield.com/ Thanks, Geoffrey Vail Brown __ Director of Online Operations Deerfield.com 231.935.4640 [EMAIL PROTECTED] Check out our complete line of Internet leveraging software at: http://www.deerfield.com -Original Message- From: PC [mailto:[EMAIL PROTECTED]] Sent: Friday, August 18, 2000 3:37 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: OT: Good inexpensive NT Email Solution I have a CF site/SQL 7 on a dedicated NT server. AM looking for an inexpensive (free?) way to setup POP email -- so that I can have up to 30 or so email addresses that map to the domain of the site. Don't know if anyone has experience that they could share -- suggesting something solid, easy to setup, etc. TIA -- 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.
Including an ASP Script in CFM
Hi, I have an ASP script that must be included in a CFM document. CFinclude does not work for this purpose. Is there any way to do this? I found the following, however, all I get is a blank screen: script language="VBScript" src="./link_generalquery2.asp" runat="server" Anyway, whatever I do, this must run from within a CFM document for security purposes. Any help would be appreciated. Thanks, Geoff B -- 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 Performance
Hi, I know this comes up a lot... but, I'm looking to drastically improve the performance of one of our CF servers. We are in the process of fine tuning some of our code so that it follows some of Allaire's suggestions on performance tuning. One server I'm running has Cold Fusion at 43 megs memory usage, and Inetinfo at 48 megs. Is that... normal? Lastly, I'm wondering, what others are running for server hardware for large scale applications? Thanks, Geoffrey Vail Brown __ Director of Online Operations Deerfield.com 231.935.4640 [EMAIL PROTECTED] Check out our complete line of Internet leveraging software at: http://www.deerfield.com -- 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.
Verity vs. Freetext
Hi, I have a large scale application that will contain a lot of data, and will require that users do frequent text searches. I am running SQL Server 7. Which would be faster - a verity collection, or using SQL 7's Full-text indexing? We are probably talking about well over 20,000 individual records. Thanks - Geoff B -- 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.
Dynamic Queries in Valuelist
Hi, I need to setup a valuelist using a dynamic query. From what I can tell, this doesn't seem to be possible. What I need is a way to drop a list of a varying number of items from a varying number of queries, and cache all of the results. Performance is key. - Geoff B -- 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.
Java WDDX
Hi, I'm looking for a way to pull some data from a script on my website using WDDX. The client application I am writing is in Java. I am able to do this easily in VB, however, VB is a little too bloated for my purposes. Is there an easy way to use WDDX in Java? I've heard that it can be done, but finding support or documentation on it is next to non-existent. Thanks Geoff B -- 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.
OT: Javascript / DHTML List
Hi, This is off topic... Can anyone recommend a good Javascript / DHTML list for advanced developers? Thanks, Geoff B -- 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.
Mapping Extensions
Hi, Does anyone know the registry entry that needs to be added so that I can have .htm files executed as cold fusion templates? I found the way to do it on PWS, but I can't find the key in IIS. Geoffrey Brown Intelliforum : Beyond HTML http://www.intelliforum.com -- 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.
Errors when using CFHTTP / WDDX on 4.5
Hi, Since I've upgraded to 4.5, using cfhttp with any xml or text templates is not working. We now get an error that states that the ascii file that we are attempting to display is invalid. To work with the data read from cfhttp, we need to dump the content to a file, then read it back in. Is anyone aware of another workaround for this? Thanks - Geoff B -- 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.
Performance
Hi, I'm looking for some advice on tuning SQL Server. We have a DB that's (let's say) 100 tables, heavily normalized, with over 250,000 records in at least 10 primary tables. For many screens within the application, we need to do two or three queries, and sometimes quite a few more, all of which must utilize the primary tables containing the most data. This obviously drags the server to its knees very quickly. The server we are running is fairly capable (single 500mhz, 512 ram, Win2k), and is dedicated only to SQL / DB tasks. We are considering adding another 500mhz to the server, which may help. In a heavily normalized database, what can one do to improve join and sub query performance? The queries mostly aggregate data for financial purposes, so some of this could be stored in a temporary table populated by a trigger, or something similar. Cached queries will not work in this situation. Help? Thanks, Geoffrey Brown [EMAIL PROTECTED] http://www.intelliforum.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.