• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

PHP - passing massive amount of data

My situation looks like this , i have a search screen where users enter search criteria, submit it
to the database and get the result. It could be even hundred thousand records.
User can select some or all of the records and go to next screen
Now on the next screen I want to show the details for each record one at a time, with  controls allowing to go to the next record. What is the best method to pass selected records on the previous screen ?. Save them to a file ?.
0
Rozamunda
Asked:
Rozamunda
1 Solution
 
sshah254Commented:
It depends on what you have and what you are dealing with.

Normally, one would not pull up all the data on the first screen ... only minimal data should be pulled up for the user to make selection of what she wants.

Once the selection is mad, some sort of identifier would be picked up and another call would be made to the db to retrieve all the necessary information on the second screen.

You can either do multiple calls ... or store the retrieved data in a file ... or session.  But if it is too much data, then you are asking for security / performance problems.

Ss
0
 
AriMcCommented:
Passing hundreds of thousands of records to a single web-page doesn't sound like a good idea simply because it will take too much time to transfer the information from your server to the client and because the user will definitely not go through that kind of amount of data.

Traditionally in these situations the search outputs an error message saying something like "More than X records found, please refine the query" and then allow/force the user to do so.

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now