Fwd: perfomance problem when adding file in big directory, StandardRDBMSAdapter unusable?

Forwarding this problem to the developer list in hopes for a response.

StandardRDBMSAdapter is clearing ALL bindings on one file update  
which makes it unusable with large folders.

Can anyone explain why?

See details below:

> Subject: Re: perfomance problem when adding file in big directory
>
> Hi we have just realised we have the same problem and are getting  
> timeouts on uploading a single file because it updates every single  
> thing in the database!
> And we even have the binding set to false in slide.properties!
>
> Did anyone find a solution to this?
>
> -Eiki
>
> On Sep 7, 2006, at 5:53 PM, Maksimenko Alexander wrote:
>
>> Hi!
>> I stuck in the following problem -
>> One of my directories has 2000 files stored in it
>> while adding file in this directory Slide adds this file as a  
>> child of the directory and updates it
>>
>> StructureImpl.class line 344 :
>>
>>    public void create(SlideToken token, ObjectNode object,
>>                       String strUri)
>>
>>
>>                    parentObject = parentUri.getStore 
>> ().retrieveObject(parentUri);                      .....
>>                    parentObject.addChild(newObject);
>>                    store(token, parentObject, true);
>>
>>
>>
>> But while storing parent directory StandardRDBMSAdapter (line 136)  
>> clears all its bindings and adds them again :
>>
>>            // update binding...
>>
>>            try {
>>                clearBinding(connection, uri);
>>            } catch (ObjectNotFoundException e1) {
>>                // clear only if it existed
>>            }
>>                      Enumeration bindings =  
>> object.enumerateBindings();
>>            while (bindings.hasMoreElements()) {
>>                ObjectNode.Binding binding = (ObjectNode.Binding)  
>> bindings.nextElement();
>>                try {
>>                    statement =
>>                        connection.prepareStatement(
>>                            "insert into BINDING (URI_ID, NAME,  
>> CHILD_UURI_ID) select ?, ?, URI_ID from URI where URI_STRING = ?");
>>
>>
>>
>> So when I add one file in this directory  Slide does 2000 jdbc  
>> calls  - and it causes very serious perfomance problems
>>
>> Why Slide clears all bindings when just updating?
>> Is there some workarounds for this problem?
>>
>> Thanks!
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>