If I inderstood you correctly, it is your code that is doing a SELECT for every file, isn't it?
Since I haven't seen your code, I cannot give you advice on this, why do you need to do a select for every file? Maybe Brett's solution can help you... did you get the time to work on this, Brett? 2010/4/27 Kenneth Vanvik Hansen <[email protected]>: > Hi, I've been working on this a bit now but I'm having some trouble when > there are many files/folders in a folder. Seems like LIST does a select for > every file in a folder. Any good ideas on how to solve this? In my db(which > is a bit slow) it can take several minutes to list 40+ files/folders. > > Kenneth > > -----Original Message----- > From: Brett M. Bergquist [mailto:[email protected]] > Sent: 23. mars 2010 17:40 > To: [email protected] > Subject: Re: LIST from database > > Okay. That will work. Thanks. > > Niklas Gustavsson wrote: >> On Tue, Mar 23, 2010 at 4:08 PM, Brett M. Bergquist >> <[email protected]> wrote: >> >>> I actually have a working Netbeans project that works against a Derby >>> database. I am going to do a little more cleanup and see if I cannot >>> factor out the database specifics like the db user manager does and >>> then I would like to provide the whole thing, probably to go into the >>> examples. So should I send this to you Niklas when I am ready? >>> >> >> If you would like to contribute the code to the project, the best way >> is to create a JIRA issue and attach the code there (making sure you >> check the donate to ASF checkbox). >> >> /niklas >> >> > > >
