Re: [sqlite] Sqlite 14 (cant open database)

2007-05-04 Thread Nuno Lucas
On 5/3/07, Arjen Markus [EMAIL PROTECTED] wrote: Lloyd wrote: That is a very large number of files! I know FAT32 can not handle files larger than 2 GB, and I imagine there is limit on the number of files as well. Try creating some subdirectories and moving the files there. The problem is most

Re: [sqlite] Sqlite 14 (cant open database)

2007-05-03 Thread Lloyd
This error occurs only on FAT 32 file system! I have a directory with 32764 files. one of the file is my sqlite database. It seems that, when the file count reaches around this particular no. the SQLite cant open database error occurs. Can anybody give me some hint? (I am mounting FAT32 file

Re: [sqlite] Sqlite 14 (cant open database)

2007-05-03 Thread Arjen Markus
Lloyd wrote: This error occurs only on FAT 32 file system! I have a directory with 32764 files. one of the file is my sqlite database. It seems that, when the file count reaches around this particular no. the SQLite cant open database error occurs. Can anybody give me some hint? (I am mounting

Re: [sqlite] Sqlite 14 (cant open database)

2007-05-03 Thread Lloyd
Thank you Arjen. I would consider your alternative or I will go for some other file system. (Because I would have to handle files larger than 2GB) Thanks and Regards, Lloyd On Thu, 2007-05-03 at 13:52 +0200, Arjen Markus wrote: Lloyd wrote: This error occurs only on FAT 32 file system! I

Re[2]: [sqlite] Sqlite 14 (cant open database)

2007-05-03 Thread Teg
Hello Lloyd, I've seen files fail on FAT32 with only 10-12K files in the folder. The problem is there's a fixed number of directory entries and when you use long filenames, more then one entry is used to store the names. So, basically you have no way to determine when the next file open will

[sqlite] Sqlite 14 (cant open database)

2007-04-24 Thread Lloyd
Hi, I am working on Redhat EL4, with sqlite3. In my application (written in C++ and wxWidgets, and I use wxSqlite3 wrapper) there a module which will be called repeatedly which in turn opens and closes the database each time the module is called. When the application runs (process the input) for