Changes between Version 29 and Version 30 of neb-touch-gory-details

Timestamp:

Feb 10, 2011, 12:19:39 PM (16 years ago)

Author:

Serge CHASTEL

Comment:

--

neb-touch-gory-details

@@ -58 +58 @@
 }}}
 
-More over since looking for the complete string is costly, it would be interesting to DESIGN the tables in the database so that search can be efficient (hash partitioning on ext_id?)
+More over since looking for the complete string is costly, it would be interesting to DESIGN the tables in the database so that search can be efficient. For instance, 10-bits string hash partitioning of tables based on ext_id might be interesting. It makes 1024 partitions for one table (and that's unfortunately the maximum). The storage_object table currently contains about TODO entries.
 
 == SQL statements decomposition: Create_object statements ==