[KLUG Members] Pages that take a mighty long time....

[Scott Wood]

--- Adam Tauno Williams <adam@morrison-ind.com> wrote:
> > What kind of data?  As in, when you say pile, is that a festering pile
> 
> SQL Database (Informix)
> 
> 1.5 million part numbers
> 1,201 Manufacturers
> 29,196 Customers
> 789 Vendors
> 2,611 Price discount structures
> 
> >of text flatfiles, an organized reaking pile of DB or XML files or a pungent
> >pile of SQL tables?
> 
> Very pungent.
> 
> Getting the data is very quick  (very nice Netfinity crouching over-yonder in
> its climate controlled lair).

OK, I am confused then - are you manipulating the data then after the fact and
the php engine is slowing you down?  Or is it something in the lookups
themselves that is adding to the time elapsed?  Sometimes external
'lookup-only' tables can help speed up large searches.  Of course, optimizing
queries in general helps performance.

Scott

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/