Closed Thread Icon

Topic awaiting preservation: A Few PHP/MySQL Questions... (Page 1 of 1) Pages that link to <a href="" title="Pages that link to Topic awaiting preservation: A Few PHP/MySQL Questions... (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: A Few PHP/MySQL Questions... <span class="small">(Page 1 of 1)</span>\

Bipolar (III) Inmate

From: Plano, TX
Insane since: Jun 2001

posted posted 09-20-2002 17:46

1) Is the performance loss (mentioned in reference books) when using the transparent URL rewrite to pass the session ID something that would really outweigh the advantages posed by not using the single cookie to store the session ID?

2) Is there anything 100% reliable for testing whether or not cookies are enabled in a browser?

3) As far as garbage collection goes... what percentage would be best if you have 1000+ users?

4) How many concurrent users can MySQL handle reliably?

Thanks in advance!

Maniac (V) Mad Scientist

From: Belgrade, Serbia
Insane since: Sep 2000

posted posted 09-20-2002 20:27

I guess that you're talking about PHP4 built-in session support, right? If so...

1. I can't say how big performance loss would be when using transparent session ID handling, but I can say that transparent session ID handling in PHP is very stupid... I've seen some web sites where PHP has added session ID even to links that point to JPEG images!? And that's really unnecessary. Also, PHP won't correctly pass session ID to scripts that you call via <FORM> tag (you'll have to add hidden <INPUT> tag with session ID by yourself). So, my suggestion would be to add session ID to all links by yourself (and not rely on transparent session ID handling)...

2. No, there isn't.

3. That depends on server load. You should monitor how many sessions are active and configure garbage collection accordingly.

4. You do know that PHP stores session data on disk and not in database? If you want to store session in database you'll have to write your own session handling functions (for saving and reading session data) and use them to replace built-in functions. Now, that we have cleared that, how many connection MySQL can handle depends on your server (hardware) and of course how MySQL is configured...

« BackwardsOnwards »

Show Forum Drop Down Menu