Re: [GENERAL] Performance critical technical key

2004-08-13 Thread Pierre-Frdric Caillaud
You could use apache mod_auth_tkt : http://www.openfusion.com.au/labs/mod_auth_tkt/ Its main advantage is that it'll authentify a user, hence your script gets the user ID, which you can use as a key in your session table for instance. Cut paste for the lazies : mod_auth_tkt is a

[GENERAL] Performance critical technical key

2004-08-12 Thread Geoff Caplan
Hi folks I'm designing a table to be used for web session management. If all goes well with the project, the table should have 100,000+ records and be getting hammered with SELECTS, INSERTS and UPDATES. The table will need a technical key. The question is, what is the most efficient way to do

Re: [GENERAL] Performance critical technical key

2004-08-12 Thread Geoff Caplan
Bruno Wolff III wrote: Using a sequence shouldn't be slow. Thanks - that's the main thing I need to know. The main potential problem is that it will make the session IDs guessible if you don't take any other steps. That may or may not be a problem. Thanks for the warning, but I won't be