Re: database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 30 Aug 2004 21:29:07 -0700, Ryan Holowaychuk <ryan@xxxxxxxxxxx> 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux