That sounds like a reasonable suggestion to me. (not that I'm volunteering to implement it, little busy on another open-source project right now).
andreis wrote: > I've got that exception a couple of times. It was not related to H2. > We were not able to find the reason and the solution. We decided it's > related to high load on NFS. > And here is my question: Thomas, what is the purpose to keep temporary > files next to the DB file? It creates unnecesary presure on a network > if the DB is placed on NFS volume (or ZFS on SAN). I'm talking about > the current implementation of Database.createTempFile(). A parameter > to set a directory for tmp files would reduce remote IO on big inserts/ > updates/selects. > > On Dec 4, 4:16 pm, Viji <[email protected]> wrote: >> Hi Andreis, >> Yes. The home directory is NFS mounted and it has lot of disk space >> too. >> Thanks. >> Viji >> >> On Dec 1, 11:43 pm, andreis <[email protected]> wrote: >> >> >> >> >> >> >> >>>> Is it related to IO on the local machine. "What is meant is Bad file> >>>> number". >>> http://docs.oracle.com/cd/E19455-01/806-1075/msgs-1050/index.html >>> "Either a file descriptor refers to no open file, >>> or a read(2)--or a write(2)--request is made to a file that is open >>> only for writing or reading." >>> I think the problem is in your environment. Is the home directory >>> mounted via NFS? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
