>I am waiting for a response from the Slide Dev Team. Is anyone currently evaluating Ashok's proposal?
Arj� -----Oorspronkelijk bericht----- Van: Kumar, Ashok [mailto:[EMAIL PROTECTED]] Verzonden: 18 April 2002 15:37 Aan: Slide Developers Mailing List Onderwerp: RE: Ashok's problem: J2EE Version Slide testing Hi Arje, >>We are experiencing the same problems in our Slide implementation. We use an HSql database as descriptor store and XMLdb >>(Xindice) the content. Currently, we run a SQL statement on the HSql database to remove all double entries once in a >>while. A patch would make me very happy! Good to know more users are finding the same problem. This particular case of multiple entries is evident when more than one users are hitting the slide for mkcol and puts. The reason being Slide handles the children as a vector and adds new children on to this vector already having the original vectors and down the line during storage instead of inserting only the new children, slide deletes all the existing children and adds all the entries in the vector which can contain duplicates. This could be avoided if we could index the children table. THis is not possible in the current database schema which has both the fields of children as varchar. Infact a fast patch which we had was the before insert get the latest children at that instance, compare with the existing vector which has the new entries to be inserted and on comparison insert only the new ones which exist there. Of course this is not fool proof as still there is chances of multiplicity. The better way is to handle it thru indexing the store tables which is impossible with the current database schema. Infact I have posted a proposal -see my mail with subject "Proposal for a more efficient New Slide Database Design" - for a modified schema with proper indexing which could avoid this problem as well as handle the db operations more efficiently. I am waiting for a response from the Slide Dev Team. Regards, Ashok -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
