| Re: Query or Array functions [message #176959 is a reply to message #176956] |
Fri, 10 February 2012 10:12   |
M. Strobel
Messages: 386
Registered: December 2011
Karma:
|
Senior Member |
|
|
Am 10.02.2012 02:18, schrieb Scott Johnson:
> 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
I think 5000 records is not much, nowadays.
We have sortable tables with client side scripting, why not filter the records with
client side scripting?
Requirement: solid knowledge of JavaScript.
/Str.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]