Re: database
| From: | Ramil Sagum | Date: | Tue, 31 Aug 2004 04:40:42 +0000 |
| Subject: | Re: database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35959@lists.php.net to get a copy of this message | ||
On Mon, 30 Aug 2004 21:29:07 -0700, Ryan Holowaychuk <ryan@hgilive.com> wrote:
>
> I have a database that has 110,000 barcodes in it.
> I am trying to create a system that I can enter barcode1 in the system and
> it return a good or bad value.
> I have it loading in an array at the moment. which does nto seem to work
> that well as it is taking a longtime and it is causing the sytem to bog
> right down.
> is there a better way to loop a variable through this many codes?
>
> thanks
>
> Ryan
You are loading all of the 110,000 barcodes in an array variable?
Aren't you using any database server? (postgres, mysql..etc) Let the
database server do the searching. :)
----
ramil
http://ramil.sagum.net