IE vs Netscape with PHP

Anon

Hi all,

I have a performance issue with some browsers when I run my program.

I have a combo box that is linked to a query. I'm using RedHat 6.2 and MySQL for my database. When I run the query in MySQL, It takes less than a second to produce 10000 records.

When I display these 10000 records in the Combo box with IE 5.0, it takes 3-4 secondes to load the page. If I use Netscape 6 it Takes 35-40 secondes to load the page.

Does anyone knows how Netscape treats the data. Is there another way to deal with this situation or a work around because I don't want to force my clients to use a specific browser.

Thanks,

Brian

Anon

I haven't seen this exact issue (a combo box with 10000 choices), but I have had pages with several hundred combo boxes (only a handful of choices each). (This happened due to an error in my sql query during development and testing.)

Anyway, I noticed that IE 5 had severe problems displaying the page. I never bothered trying it in Netscape because I knew it was an error in the query.

I would suggest coming up with a different solution than forcing a user to wade through 10000 choices in a combo box. Perhaps allow users use a search string, then display the matches (hopefully less than 10000) and let them choose from those.

Good luck.

Anon

Thanks for your reply.

The reason I have 10000 choises it's because it's a program that has Drug Names and you can select more than one name to search for information about that drug. I have also a narrow down function but because you can select more than one drug I have to load the full list. My narrow down function is on the same page as the list. So i guess I'm in a vicious circle !

Thanks

Brian

Anon

well i am not sure why this is occuring but im going to throw on some guesses for fun. One thing it could be is that you are missing some critical html code. like an < / table > or something like that, which IE would say 'hey a close table belongs here' and do it for you where netscape may freak out and take for ever on deciding what to do.
You can be pretty sure that it isn't any of your database stuff or php. It is in the way you are displayin the data. EIther the html is kinda weird when its gettin written or Netscape isn't liking all of the form controls and is takign a long time to print them. Id go through your code mainly your html to see if there are any slight errors.

But i am just guessing and have no idea if this is close to being right 🙂
but good luck.

neuromancer

IE > Netscape

Anon

Thanks for the ideas, I will double check my HTML code to see if I'm not missing anything.

Thanks

Brian

polson

Yeah, this is an html/client-side related issue and has nothing to do with PHP. You may want to run it through :

http://validator.w3.org/

It's pretty strict but can be very useful.

neuromancer

as a_dumb_validation_script05 throws 100000 errors for stupid stuff.

polson

What? I don't understand either of your posts, please explain.

rrijnders

as unwise_programmers count(on_browsers) {
...to_fix(bad_html);
}

;-)

parena

How about displaying your drugs like this:

box 1: aa-am
box 2: an-az
box 3: ba-bm
etc...

something like that... Or even "only" 26 combo boxes (each letter of the alphabet)

Anon

yeap.

Sorry, no offence intended, but nobody ever displays 10k lines in one page. The browser problem is just the top of the iceberg.

Paste your code here. We can help you
(or steal it of course🙂

Calin

Anon

I think you need an evil laugh after the stealing the coding bit. somthing like this-

muwhahahahahahaaaaaa

lol