Re: Database use in CircleMUD (was Re: [Code] Native Database Driver)Support

From: Michael Lemler (coronach@succubus.datacruz.com)
Date: 04/02/99


-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: PGPfreeware 5.0i for non-commercial use

mQGiBDbi2ycRBADp6Vd7plah6vVhCx+TdkKimp1ALa+nVgpS4FuZHeO4Kk5U9Jak
R3QTjP2lkLt7nY7c422H5iabtG5DNbASaDQhuK/As2pAZnEMNCAW2QkE4UK1s33x
EIubZrHMPZX9bE0KZ9YFFW8fQsDuw6CNo4LFccc+22JnafLXl2L3ezLfTQCg/71B
k02f9GK9Lt0/JxoBt1voi3sEAMf8opaiUlWh4SJOkXZTf2Zvl3SLCjTXbi878IHJ
tw4hAKzCm1Z/djfpsSeS4h8IxSqmoPJM8i0a2vLfvq4h9D4fLBUbCPTOuQ2NZqjW
zVw8xGILOV/JrfO76ge3+F48P2a/b/CFGu90FmPDpZv/1QTCcugKFKmtuDitk3GI
sL9fA/oDNdO1cgMtlnXxgV7xguYQZK1H5r5i1XBEMhTIKFNKClbbGEQh/GXjOnT0
aLZUmh2rccEtLPCYaMxRHaeO+tl2OjjGn8Ajv28D27SwljMT57lVoXb/hPROECM3
gzwIraVeF2D/LvRuBEg4aYFdmr+YxMSUdKUSYwWhNe4bSm4Y8rQIY29yb25hY2iJ
AFEEEBECABEFAjbi2ycFCQCeNAAECwMBAgAKCRADj15ehEKaT66yAKC3+sVulD5F
RfKLy5MXEFW0IdE+4ACg2VwI0W/Vu9PUJAobBi0Km3vGPh25Ag0ENuLbKBAIAPZC
V7cIfwgXcqK61qlC8wXo+VMROU+28W65Szgg2gGnVqMU6Y9AVfPQB8bLQ6mUrfdM
ZIZJ+AyDvWXpF9Sh01D49Vlf3HZSTz09jdvOmeFXklnN/biudE/F/Ha8g8VHMGHO
fMlm/xX5u/2RXscBqtNbno2gpXI61Brwv0YAWCvl9Ij9WE5J280gtJ3kkQc2azNs
OA1FHQ98iLMcfFstjvbzySPAQ/ClWxiNjrtVjLhdONM0/XwXV0OjHRhs3jMhLLUq
/zzhsSlAGBGNfISnCnLWhsQDGcgHKXrKlQzZlp+r0ApQmwJG0wg9ZqRdQZ+cfL2J
SyIZJrqrol7DVekyCzsAAgIH/1ah3MNk8574wYrebj3CQu/50PZpPQUnGX07cnq/
HuKdc12xD/6uvvtkc8iR0/8cllOlhQ/2hxwr7eXsXfbzCyQS6PmnAcfrIKJVDRz8
xhemEyDYEtM+UMQQxcZ8RyxDhUIKh6xu0r/3vwxndLVCaFi/xepWC3jkZ9WZoRdX
DKrEwJjTVzwS2tzPlVF4hKygbLsj1mvjeS6me38fxKgXYEj1K7EcCdwJFNjeyuzY
sQBriz3KWjzutjtk2a5Y4FTtWmLOqQTANG6yvXUCYODmH3Z99oMeWMF0yIr+PQV4
l0wZF3RwLx9Uumv+uwJ+bQZjw0YOVNIIMmmjwtv7bxFF4zKJAEwEGBECAAwFAjbi
2ygFCQCeNAAACgkQA49eXoRCmk+58wCfW2g8VrPA3WXbBPL1ERIqEApsKREAnjNP
Hx/ICr7AYQkhve6QzjOx9flX
=K9aD
-----END PGP PUBLIC KEY BLOCK-----

On Fri, 2 Apr 1999, George Greer wrote:

> However, I'm not limiting the database to just SQL, it'll do arrays, hash
> tables, and binary trees too.  All at the same time too.  You can have

Well, with a good database engine, you can have all that stuff be done for
speed issues on the database backend.  It depends on how you optimize the
tables (as said above, data normalization is a Good Thing(tm)).. I am not
too familiar with MySQL, but postgres gives you options of the different
trees and hashing you can use to custom fit to the task/data.

--Mike


     +------------------------------------------------------------+
     | Ensure that you have read the CircleMUD Mailing List FAQ:  |
     |  http://qsilver.queensu.ca/~fletchra/Circle/list-faq.html  |
     +------------------------------------------------------------+



This archive was generated by hypermail 2b30 : 12/15/00 PST