<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
M.E. <br>
<br>
You provided a link to an excellent article with many great points
and a compelling argument for keeping images in a separate file
system based on both I/O and database considerations. I yield to
overwhelming experience on that.<br>
<br>
So, how best to architect the format, indexing, and evolution of
the many-terabyte file system for the particular situation in hand,
virtual world assets?<br>
<br>
Given the localization, clustering and clumping nature of related
textures, it makes me wonder if a tree-structured index system,
instead of a relational-database flat-table structure, would make
the most sense -- ie, some language like MUMPS.<br>
<br>
Has someone else already solved this type of problem in the
literature and practice?<br>
<br>
Your thoughts on that?<br>
<br>
Wade<br>
<br>
<br>
On 3/9/12 1:33 AM, M.E. Verhagen wrote:
<blockquote
cite="mid:CA+RcaTS=mm0mh2Sio6x+T6iD7VGY=o3jT-EHjzcf=OtE7_KEgA@mail.gmail.com"
type="cite">this is a bit of an old article: <a
moz-do-not-send="true"
href="http://mysqldatabaseadministration.blogspot.com/2008/01/i-will-not-blob.html">http://mysqldatabaseadministration.blogspot.com/2008/01/i-will-not-blob.html</a>
<div><br>
</div>
<div><span style="font-family:'Trebuchet
MS',Verdana,Arial,sans-serif;font-size:13px;line-height:18px;text-align:left;background-color:rgb(255,255,255)">qoute:
'The concept of databases is generally suited to storing a
very large number of objects that are small in size. Here,
both "very large" and "small" are relative to each industry
and requirements of the system. When you look at overall
picture, file systems are more suited to handling large
objects, especially if the large object consists of an image.'</span></div>
<div><span style="font-family:'Trebuchet
MS',Verdana,Arial,sans-serif;font-size:13px;line-height:18px;text-align:left;background-color:rgb(255,255,255)"><br>
</span></div>
<div><span style="font-family:'Trebuchet
MS',Verdana,Arial,sans-serif;font-size:13px;line-height:18px;text-align:left;background-color:rgb(255,255,255)"><br>
</span></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Opensim-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-dev">https://lists.berlios.de/mailman/listinfo/opensim-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>