| Re: Query or Array functions [message #176958 is a reply to message #176956] |
Fri, 10 February 2012 08:26   |
alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma:
|
Senior Member |
|
|
El 10/02/2012 2:18, Scott Johnson escribió/wrote:
> 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.
If you are worried about retrieving matching rows from a 5000 row DB
table using a SQL query, I doubt that using a file to store a serialized
5000 element bi-dimensional array and looping though it to find matches
will be faster; not to mention the mess of keeping data up-to-date and
taking care of concurrent access.
A 10,000,000 record table is a big table. A 5,000 record table is not.
Just make sure that your SQL knowledge goes beyond "SELECT * FROM foo".
I've seen too many amateurs in forums building web sites without even
using the WHERE clause.
--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]