Solved

PHP - passing massive amount of data

Posted on 2011-03-23
2
293 Views
Last Modified: 2012-05-11
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
Comment
Question by:Rozamunda
2 Comments
 
LVL 9

Accepted Solution

by:
sshah254 earned 250 total points
ID: 35202962
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
 
LVL 9

Expert Comment

by:AriMc
ID: 35202965
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now