• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

how to use cfquery result in other page?

New Here ,
May 20, 2009 May 20, 2009

Copy link to clipboard

Copied

hi,

i have a big big query in pageA.cfm ,for example

<cfquery name="rsGetStudent" datasource="#str_conn#" cachedwithin="#CreateTimeSpan(0, 0, 30, 0)#" >

     select * from student_all

     where 1=1

     #SQLFilteringDependOnUser#

</cfquery>

this query will return about 100,000 row.
i want to take the result in query "rsGetStudent" to page B. how do i do that?
using session?
using URL parameter?
any suggestion?
thank you....

TOPICS
Advanced techniques

Views

844

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
May 20, 2009 May 20, 2009

Copy link to clipboard

Copied

If the results are specific to a user then use the Session scope. If

all the users share the results then use the Application scope.

Mack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 21, 2009 May 21, 2009

Copy link to clipboard

Copied

thanks for the suggestion Mark...

i just want to know if there is a performance issue when using Session  or Application to hold a 100,000 row of data accros the application?

do i need a bigger RAM ?

does my application will be slow in performance?

currently i don't use Session or Application variable to hold big big data... just the user login information only.

thank for any suggestion...

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
May 21, 2009 May 21, 2009

Copy link to clipboard

Copied

Holding 100,000 rows of data will surely influence some aspects of

your server performace. How much it affects the server depends

primarily on the type and amount of data that is in the rows: numeric

types take less memory space then string types, more columns also mean

more memory space, etc. The obvious optimization here is to find a way

not to retrieve and store that amount of data in the first place: you

can use the database to retrieve only the rows that you need to be

displayed at one time.

You can check how big is the impact by using the Server Monitor to

monitor the memory consumption.

Mack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 21, 2009 May 21, 2009

Copy link to clipboard

Copied

LATEST

Run it again.  You have it cached.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation