Run this in query analyser and paste the results..
SET STATISTICS ON
EXEC getPageData 12345
-----Original Message-----
From: Paul Johnston [mailto:[EMAIL PROTECTED]
Sent: 04 July 2003 10:39
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Cookies anyone..
Surely (if coded correctly) it would be:
EXEC getPageData 12345
(where 12345 is a page ID)
And that would return either a recordset or value of some sort. Make the
database do the work! There's no point in having a dynamic site if you
aren't going to make the database do at least most of the work!
Paul
> -----Original Message-----
> From: Robertson-Ravo, Neil (RX)
> [mailto:[EMAIL PROTECTED]
> Sent: 04 July 2003 10:34
> To: '[EMAIL PROTECTED]'
> Subject: RE: [ cf-dev ] Cookies anyone..
>
>
> LOL I am sure there are...but its not really practical to -
> or maybe it is....I would like to see the statistics io from
> the SQL box to see the reads etc..
>
> -----Original Message-----
> From: Paul Johnston [mailto:[EMAIL PROTECTED]
> Sent: 04 July 2003 10:32
> To: [EMAIL PROTECTED]
> Subject: RE: [ cf-dev ] Cookies anyone..
>
>
> > I do and I was merely highlighting the fact that its aint
> > really logical is it....as how many sites do you you have
> > which look like this..
> >
> > <cfquery>
> > GET ALL THE PAGE INFORMATION FROM THE DATABASE
> > </cfquery>
> >
> > There is NEVER going to be a site where you are "pulling all
> > the stuff from the database"
>
> I have worked on sites that pull all of the page info from
> the database (except maybe the header and footer... But if
> they are constant, that's 2 files to change) and they work
> very well... Also, if you think about it, if all links are
> stored in a database, then you have a purely dynamic site...
> Lots of work and not necessary for very many sites (except
> very big sites), but... Never say never!
>
> Paul
>
>
>
> --
> ** 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]
