Thats what i wanted to ask. Is it too much to hold in memory? We have 2 GB but the amount of text will grow and of course everytime the cf service is restarted this BIG loop will have to be done again.
Would it not be better to have a page/text relation table and do a query everytime? Maybe cache the queries per hour or even cache to HTML. More opinions please. Thanks Allan ----- Original Message ----- From: Stephen Pope To: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 12:49 PM Subject: RE: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site Isn't that a lot of stuff to hold in memory ? Unless of course you have masses hehe ! Stephen -----Original Message----- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 06 October 2003 11:48 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site <CFLOOP QUERY="q_GetTexts"> <CFSET "application.T#textid#L#Languageid#" = Text> </CFLOOP> Single loop only. ----- Original Message ----- From: Damian Watson To: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 12:40 PM Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site > Then Burn into application memory T1234L1 as variables in a double loop That's kinda gone over my head... what does this mean? How would do you do it? Cheers :) ----- Original Message ----- From: "Allan Cliff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 06, 2003 11:36 AM Subject: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site I personally was going to have all the texts in 1 table related by textid, languageid, text, Then Burn into application memory T1234L1 as variables in a double loop and then read them from the page depending on a cookie. (if set) T1234L#Languageid# on each page. ----- Original Message ----- From: Damian Watson To: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 12:26 PM Subject: [cfmail] Re: [ cf-dev ] Multi-language site I've just been doing similar... I have different tables for each language. The site administrators can edit these in the CMS -- they are set up on a permissions basis to access content in certain languages. When a user visits the site a session variable is set up called session.lang defaulted to "" which retrieves content from a table "tableName" -- then if they choose Swedish for example it is set to "sv_" -- this will then retrieve content from sv_tableName through dynamic query. This is handy in this instance as there is a pile of textual content on this site. Have other people done this or are there more suitable methods as I have several languages to go yet! d ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 06, 2003 11:05 AM Subject: RE: [ cf-dev ] Multi-language site > We personally use tables for this, and load them into Mem.....if you need > any info....please get in touch. > > -----Original Message----- > From: Allan Cliff [mailto:[EMAIL PROTECTED] > Sent: 06 October 2003 10:55 > To: CF - List > Subject: [ cf-dev ] Multi-language site > > > We are thinking of making a site multilanguage. Has anyone any experience on > this? > > I did something a long time ago and i was planning to have a text table and > a language table. > Then to either send all the texts into the application scope and read them > from cf memory or call the db on every page? > > I suppose it would depend on the size of the texts etc. > > Anyone got any hands on experience. We are talking about a site with more > than 2 million hits per month. > > Thanks > > Allan > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
