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>
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
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...
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
Copy link to clipboard
Copied
Run it again. You have it cached.