| Query or Array functions [message #176956] |
Fri, 10 February 2012 01:18  |
Scott Johnson
Messages: 196
Registered: January 2012
Karma:
|
Senior Member |
|
|
OK I will try to ask this and make sense out of this also.
First off I am doing this on a back-end admin page.
I have a DB with lets say 5000 records and a dozen or more fields.
On the page which will display these records I am planning on using
pagination to display so many records at once. So far so good.
What i would like to do is provide a row above the table of records
where the user can enter text to filter the display on each column.
I plan to use AJAX and filter as the user types which in itself is not a
problem.
The problem I see is the numerous DB queries and I don't see querying
the DB each time the user types a letter as a practical approach. (I
could be wrong).
What I was thinking of doing is loading the full record set into an
array and then filter out the array of the needed data as the user types.
I have not done any intense array manipulations like this before and am
wondering if this seems like a practical approach.
I would like to ask for any advice or suggestions on this. I may even
have my head in the wrong area and not see the forest thru the trees.
Thanks
Scotty
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]