Performance critical technical key
От | Geoff Caplan |
---|---|
Тема | Performance critical technical key |
Дата | |
Msg-id | 166360425184.20040812130545@variosoft.com обсуждение исходный текст |
Ответ на | Re: Correct escaping of untrusted data (Geoff Caplan <geoff@variosoft.com>) |
Ответы |
Re: Performance critical technical key
Re: Performance critical technical key |
Список | pgsql-general |
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 this? a) Generate a random 24 character string in the application. Very quick for the INSERTs, but will the longer key slow down the the SELECTs and UPDATES? b) Use a sequence. Faster for the SELECTS and UPDATES, I guess, but how much will the sequence slow down the INSERTS on a medium sized record-set? There will probably be 6-8 SELECTs & UPDATEs for each INSERT. I appreciate that I could set up some tests, but I am under the hammer time-wise. Some rule-of-thumb advice from the list would be most welcome. ------------------ Geoff Caplan Vario Software Ltd (+44) 121-515 1154
В списке pgsql-general по дате отправления: