Re: Database Interations - overloaded sites
Well, the question is more complicated than that. It really comes down to what your system does. If it's an online spreadsheet program, theres going to be a large amount of database interaction and you are not going to be able to store very much of it in the session. Now, if it's some sort of logged in intranet/extranet where users come to get standardized information, that may be stored in the database, you can do all sort od preformance tuning using cached queries in shared scopes like Application or Server. It all depends on what level of data interaction your app will expose to the users. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Interations - overloaded sites
thanks for your reply alan. the system is not quite a complicated as a spreadsheet system, but also not a system for standardised data. The system could appear to be like a course management system, therefore each users data will be different. so although it wont need as much interaction with the database as a spreadsheet, i cant used cached data on the server or applicatiion variables. So, i suppose it just comes diwn to judgement? thanks again ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Database Interations - overloaded sites
how do you feel about storing data in the session variable. as i think for storing the data in it will be great as if they are navigating among pages and come back to a page they were on before, then i would just check to see if the data is in the session variables. This would drastically lessen on the load on the database and the pre-processing needed for each page. but i see what you mean it depends on the amount of data that will be getting stored in the session variable. if it is down to judgement, there are certain wizards where the users will go through around 10 steps for each course they are undertaking. at the end of these wizards the session variables holding the data can be flushed. So i see what you mean it is all dependant on what you are doing thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Interations - overloaded sites
Database data is also less volatile than session data. If a person is called away from your signup process in the middle, and comes back after the session has expired, do you want them to be kicked back to start over? The answer might be Yes but you need to plan for stuff like that. One thing I would be leery of is relying on session vars on a shared CF server (i.e. a $20 or $50 monthly hosting account). If this is a box dedicated to your site I wouldn't worry so much, if at all. There's no set rule for any of this, but definitely less db access a good thing. On 9/25/06, Richard White [EMAIL PROTECTED] wrote: how do you feel about storing data in the session variable. as i think for storing the data in it will be great as if they are navigating among pages and come back to a page they were on before, then i would just check to see if the data is in the session variables. This would drastically lessen on the load on the database and the pre-processing needed for each page. but i see what you mean it depends on the amount of data that will be getting stored in the session variable. if it is down to judgement, there are certain wizards where the users will go through around 10 steps for each course they are undertaking. at the end of these wizards the session variables holding the data can be flushed. So i see what you mean it is all dependant on what you are doing thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Database Interations - overloaded sites
thanks very much for your reply, yes it will be our own server, but good point about being kicked back to the start. thanks again ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4