ColdFusion Server x Hardware
Ok... Thanks for everybody ! I am using an Oracle database with CF5.0 and IIS 5.0... All of them in same machine... So i think that overload my machine, but as all of you said, my actual configuration is very good... Thanks again. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion Server x Hardware
Dan and Tony, thanks for your reply ! Well, i have more than 1000 users registered in my system and i have 40 simultaneous users making queries. With that enviornment, my hardware is good ? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion Server x Hardware
Dan, i plan on running CF5 ! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion Server x Hardware
Hi ALL ! Where can I have a good documentation about good hardware for ColdFusion Servers ? I have actually a Pentium 4 1.8Mhz (one processor), 512mb RAM and 100gb HD, running WinNT and sometimes the server goes down I know my problem isn't at all with my machine, but I want a reference that compare the number of simultaneous users versus machine configuration... Thanks ! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pagination issues
Cedric, i dont wannt to call both queries everytime... i'm prefer call the first query only once and store the ID in a variable, like session or anything else... I can't ? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pagination issues
Sure ! I cand do that, but my problem is the query into that procedure... First i would like to know if ColdFusion has any method or function like VB or DELPHI (may be a Java component), that i can use like a pointer to database. If i couldnt do that, i will try the Cedric method with 2 queries... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pagination issues
Greg, i am making a procedure and sending a resultset from a cursor to ColdFusion. The problem is the query from my procedure... :) I am using the Cedric suggestion and it is working well... But i am still trying to find another way... Thanks ! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pagination issues
Cedric, i tryed and it worked very well ! But i have two questions: 1 - I have to put an 'order by id' in first query, right ? 2 - If i have 1.000.000 of returned rows, how can i pass the ids from first query, over pages and look for them in listGetAt ? Form Fields can store more than 1.000.000 chars ??? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pagination issues
Hi Ian ! I cant store in any type of ColdFusion memory because i work with a large amount of data and users... So i dont want to overload my server... Thanks ! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pagination issues
Cedric, i will try your sugestion. Thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pagination issues
Ian, the problem is, that i dont want to return all 1000 rows on every page. This cause a performance degradation, so i look for another way to solve my problem... Thanks, Rodrigo Cohen. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pagination issues
Hi all ! I have a simple question about pagination for queries with big resultsets... :o) I have a query that retuns about 1000 rows. But i show only 10 rows per page. I read at many articles, to use startrow and endrow in CFOUTPUT QUERY tag to make paginations but i dont like that way... So i am making the same query with some new sql commands, that can return to me, only the 10 rows per page that i want... (depending which page i am). The original query with 1000 rows is: SELECT field_1, field_2, field_3, field_4, field_5 FROM my_table WHERE field_1 = '' AND field_2 = '' ORDER BY field_5 The new query with only 10 rows, showing the 3th page for example (from row 21 to row 30), is: SELECT * FROM (SELECT query_result.*, rownum r FROM (SELECT field_1, field_2, field_3, field_4, field_5 FROM my_table WHERE field_1 = '' AND field_2 = '' ORDER BY field_5) query_result where (rownum) < 31 ) where r > 20 At my ColdFusion Debug, the execution time of second query is a half of the first query. To me, its perfect ! But my DBA MAN, sad to me, that running Trace File (from Oracle), the attribute DISK (number of physical reads of buffers from disk) increase with 25% from the frist to the second... So i wanna help ! :) I am doing the right thing ? Or ColdFusion has another way to make paginations with no all rows returned (like VB, DELPHI, or any other language that i can use a pointer to database object, like DBGRID and read only some rows from DB at time) ? Note1: i cant use the MAXROWS attribute at my CFQUERY because i have many pages and i need the start and end row... Note2: i dont want to use cached queries because i have too many paginations, with too many filters, with too many users and those paginations filters are always changing. Thanks a lot ! Rodrigo Cohen. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Exporting dynamic data to MS WORD 97 W/Out COM
Full message again... :) Hi ! I am trying to export some data to MS Word 97 but i am using Solaris, and i cant use COM Objects.. O know the issue of make a standard RTF document and make some replaces of my cf-variables with RTF vars. Like below: RTF DOC: Name: %myName% Age: %myAge% . CF TEMPLATE: Make a READ with CFFILE Make the replaces like: (replace RTF, "%myName%", name) .. Make CFHEADER and CFCONTENT Make Output of the result Oka, the problem is that i have some loops and i want to export the exact layout of my HTML page with HTML tags(table,Css). I know some XML issues, but this work only with office 2000 and i am using 97... With a simple CFHEADER and CFCONTENT, the MS WORD 97 receives the HTML code with no parse and no conversion of html tags... Any ideas ? Thanks, Rodrigo. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Exporting dynamic data to MS WORD 97 W/Out COM
Sorry, here is the full message: Hi ! I am trying to export some data to MS Word 97 but i am using Solaris, and i cant use COM Objects.. O know the issue of make a standard RTF document and make some replaces of my cf-variables with RTF vars. Like below: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Exporting dynamic data to MS WORD 97 W/Out COM
Hi ! I am trying to export some data to MS Word 97 but i am using Solaris, and i cant use COM Objects.. O know the issue of make a standard RTF document and make some replaces of my cf-variables with RTF vars. Like below: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 5 Crash when using cursors
Hi all ! My CFSERVER is crashing when i call a Stored Procedure in Oracle that uses Ref Cursor. With PLSQL Developer it works very fine... With ColdFusion it works too when the Cursor is opened. The problem is hapening when the procedure makes a RAISE EXCEPTION before the cursor be opened. I think that is possible to assing a NULL default value to cursor, and then i will retun null if not opened. I am using CF 5, with Oracle 8i. Any ideas ? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
