Re: [sqlite] How to deal with Filesize-Limit of 2GB on Windows 95

2004-06-18 Thread Darren Duncan
At 2:28 AM +0200 6/19/04, Roberto Saccon wrote (by direct email):
Thanks, but I have no control over the computers of people using my 
application. Of course this is not a problem for my own system, but 
believe me, there are millions of people ot there with such old 
systems.
Roberto
Who says you have no control?  Why not just indicate operating 
systems that support files larger than 2GB in the requirements for 
your application?  Or more specifically, state that they must have a 
good operating system in order to use Multimedia data collections 
that are individually larger than 2GB.  Those with less capable 
operating systems can explicitely use multiple data collections 
(SQLite files), or keep theirs under 2GB.  That's how I suggest you 
deal with the problem.  Trying to support larger files on operating 
systems that aren't designed for it is a cludge and probably won't 
help a lot of people.  The only reason I see you may have to go to a 
lot of trouble is if you were explicitely given requirements that the 
application must support files over 2GB on Windows 95. -- Darren 
Duncan

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: [sqlite] How to deal with Filesize-Limit of 2GB on Windows 95

2004-06-18 Thread Darren Duncan
At 1:58 AM +0200 6/19/04, Roberto Saccon wrote:
Hi all
I am a happy user of sqlite, but currently  my filesizes are little, 
because I store Multimedia data on a Berkeley-DB-like storage 
(QDBM), which can be splitted into several files. Now I am thinking 
about storing the multimedia data also with sqlite in the upcoming 
3.0 release, because it has native BLOB support. Well, I haven't 
done  any test yet about performance, but one concern I have is the 
filesize limit of 2 GB on MS Windows  95. Does sqlite provide some 
way of splitting the database file in small pieces ? How are other 
developers dealing with this filesize isssue for old MS Windows 
systems ?
regards
Roberto
P.S. if this qustion has been anwsered before, this is my first post 
to the list, and I really googeled a lot about the topic, but didn't 
found anything.
I suggest you could upgrade to a better operating system.  Any 
computer new enough to have hard drives much larger than 2GB should 
also be able to handle a better operating system without choking. -- 
Darren Duncan

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


[sqlite] How to deal with Filesize-Limit of 2GB on Windows 95

2004-06-18 Thread Roberto Saccon
Hi all
I am a happy user of sqlite, but currently  my filesizes are little, 
because I store Multimedia data on a Berkeley-DB-like storage (QDBM), 
which can be splitted into several files. Now I am thinking about 
storing the multimedia data also with sqlite in the upcoming 3.0 
release, because it has native BLOB support. Well, I haven't done  any 
test yet about performance, but one concern I have is the filesize limit 
of 2 GB on MS Windows  95. Does sqlite provide some way of splitting the 
database file in small pieces ? How are other developers dealing with 
this filesize isssue for old MS Windows systems ?

regards
Roberto
P.S. if this qustion has been anwsered before, this is my first post to 
the list, and I really googeled a lot about the topic, but didn't found 
anything.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]