• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • 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 ?.
1 Solution
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.

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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