table design question
От | George Johnson |
---|---|
Тема | table design question |
Дата | |
Msg-id | NEBBJGKMGLGMDGBMOHJNOEFFCAAA.gjohnson@jdsc.com обсуждение исходный текст |
Список | pgsql-general |
Hello All, I need some advice regarding table column types and read speeds. I have a database of protein sequence data (strings of characters mostly including 20 alphabet characters) and nucleotide base sequence data (strings of characters mostly including a,t,g,c). When I wrote the homegrown backend to our database way back when, I cooked up some fun ways of storing the data for very fast access speeds (not really interested in doing SQL-ish searching on the columns in place). I'm wondering what the best choice of storage is: just leave them as text strings, do some fancy hexidecimal conversion, etc? Or does it matter? The tables for the most part contain the sequence information as well as a primary key. Any thoughts/suggestions would be useful. Happy Holidays (oh ... darn ... it's going to be 60's and sunny AGAIN on the peninsula today [nudge to back-east bretheren] heheh) George Johnson
В списке pgsql-general по дате отправления: