Changes between Version 32 and Version 33 of neb-touch-gory-details

Timestamp:

Feb 10, 2011, 4:48:35 PM (16 years ago)

Author:

Serge CHASTEL

Comment:

--

neb-touch-gory-details

@@ -55 +55 @@
 ''Comment:'' Could be simplified since the only information which is used is (at the neb-touch script level): is there something called like that?! No need for so many joins!
 
-''Suggestion'': Test with
+''Suggestion'': Test existence with
 {{{
 SELECT ext_id FROM storage_object WHERE ext_id = ? LIMIT 1
@@ -62 +62 @@
 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). For information, the storage_object table currently currently contains about 3.7e+8 entries.
 
+''Implementation'': in modified ''Server.pm'' as ''exists_object''
 == SQL statements decomposition: Create_object statements ==