we do this... hopefully it makes sense <cfquery name="qGetNumMsgs" datasource="#ds#"> select count(imessageid) as msgcount from messages where ithreadid=#threadid# </cfquery>
then you have the number of messages and it only returned one record to do it. Tim Storm Fatwallet.com ----- Original Message ----- From: "Daniel Chicayban" <[EMAIL PROTECTED]> To: "CF-Linux" <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 3:43 PM Subject: Re: mysql/coldfusion/linux/dual processor > MMm i dont think so. I think I didn't explain very well. > > How would you output on the HTML something like this: > |Previous 5| |Next 5| of 265983300 records. > > How would you know this huge number? Because using LIMIT your > query.recordcount will have #maxrows#-#start# records, right? > > Daniel > > At 03:40 PM 12/14/2001 -0600, you wrote: > >LIMIT #start#,#maxrows# > > > >Does that answer your question? > > > >----- Original Message ----- > >From: "Daniel Chicayban" <[EMAIL PROTECTED]> > >To: "CF-Linux" <[EMAIL PROTECTED]> > >Sent: Friday, December 14, 2001 3:31 PM > >Subject: Re: mysql/coldfusion/linux/dual processor > > > > > > > Yes, LIMIT makes a good diff, but let me ask you something: if you place > > > LIMIT on your queries, so you just get a determined amount of records. Ok, > > > how would you do to build a page turning, if you can't get a total of > >records? > > > > > > I was thinking about that there and I realized that I would have to > > > count(), and another query like that would be really worse. What you > >think? > > > > > > Daniel > > > > > > At 03:25 PM 12/14/2001 -0600, you wrote: > > > >Both! > > > > > > > >We found LIMIT to be very critical! and it stands to reason too! > > > > > > > >Tim > > > >----- Original Message ----- > > > >From: "Daniel Chicayban" <[EMAIL PROTECTED]> > > > >To: "CF-Linux" <[EMAIL PROTECTED]> > > > >Sent: Friday, December 14, 2001 3:10 PM > > > >Subject: Re: mysql/coldfusion/linux/dual processor > > > > > > > > > > > > > Hi Tim. > > > > > > > > > > Good to know. About the mysql: I am caching the queries now. In > >queries I > > > > > was getting more than 10000 msecs, now I get 2/3msecs. It's solving > >very > > > > > well the problem here. > > > > > > > > > > When you say "returning what is absolutely necessary" you mean LIMIT > >x,y > > > >or > > > > > SELECT IwantThis, IwantWhatever from Table? Or both? > > > > > > > > > > Daniel > > > > > > > > > > At 02:59 PM 12/14/2001 -0600, you wrote: > > > > > >I've got CF5 on a dual 1ghz P3 box, and MySQL on a dual 1Ghz P3 scsi > >raid > > > > > >box (both have 1GB Ram) - purchased from pogolinux.com fwiw. > > > > > > > > > > > >it probably goes without saying, but make sure your queries are only > > > > > >returning what is absolutely necessary... we were sloppy early on and > > > >didn't > > > > > >limit the queries to just the number of records we needed.... later > >on > > > >when > > > > > >we fixed it we were able to cut our total page loads by a factor of > >10. > > > > > > > > > > > >Tim Storm > > > > > >FatWallet.Com > > > > > > > > > > > >----- Original Message ----- > > > > > >From: "Daniel Chicayban" <[EMAIL PROTECTED]> > > > > > >To: "CF-Linux" <[EMAIL PROTECTED]> > > > > > >Sent: Friday, December 14, 2001 2:52 PM > > > > > >Subject: mysql/coldfusion/linux/dual processor > > > > > > > > > > > > > > > > > > > Does anyone has unsuccessful or successful cases running cf with > > > >mysql, cf > > > > > > > 5 and dual processor box? > > > > > > > > > > > > > > I have an app that is demanding too much from the mysql server. I > > > >wonder > > > > > >if > > > > > > > I change a pIII 500Mhz (512mb RAM) to a powerful one or maybe two > > > > > > > processors, I would have more performance in my queries. > > > > > > > > > > > > > > Any article, faq etc would be great too. > > > > > > > Thanks in advance. > > > > > > > > > > > > > > Daniel > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
