Caching your queroies has to be just as quick. > -----Original Message----- > From: Allan Cliff [mailto:[EMAIL PROTECTED] > Sent: 06 October 2003 12:00 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] > Multi-language site > > > 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] > > >
-- ** 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]
