NYCPHP Meetup

[Adam Fields]

On Tue, Jul 12, 2005 at 11:49:09AM -0400, harvey wrote:
> It's not for the user, it's for the admin to select bands when he is 
> entering a new show.

Still - break it up alphabetically or something.

Actually, this is a perfect opportunity for you to try out that
XmlHttpRequest object you've been dying to use.

A few other suggestions:

1) Yes, use an outer join as previously suggested.

2) Make sure you check your indexes.

3) Is the query taking a long time, or is the page taking a long time
   to build/load? That's important to know.


> Believe it or not, they're all bands that have performed in NYC over the 
> past few months.
> 
> And even the slow query only takes about 6 seconds to load.
> 
> But, yes, I am crazy.
> 
> 
> 
> 
> At 10:48 AM 7/12/2005, you wrote:
> 
> >4000 bands in a drop down box, are you crazy?
> >
> >i would make the user choose a state or city then only show the relevant 
> >ones to make your query faster.
> >
> >--
> >Joseph Crawford Jr.
> >Codebowl Solutions, Inc.
> >1-802-671-2021
> ><mailto:codebowl at gmail.com>codebowl at gmail.com
> >_______________________________________________
> >New York PHP Talk Mailing List
> >AMP Technology
> >Supporting Apache, MySQL and PHP
> >http://lists.nyphp.org/mailman/listinfo/talk
> >http://www.nyphp.org

> _______________________________________________
> New York PHP Talk Mailing List
> AMP Technology
> Supporting Apache, MySQL and PHP
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.nyphp.org

-- 
				- Adam

** I can fix your database problems: http://www.everylastounce.com/mysql.html **

Blog............... [ http://www.aquick.org/blog ]
Links.............. [ http://del.icio.us/fields ]
Photos............. [ http://www.flickr.com/photos/fields ]
Experience......... [ http://www.adamfields.com/resume.html ]
Product Reviews: .. [ http://www.buyadam.com/blog ]