1) Can I assume that MAX_PAGE_COUNT * PAGE_SIZE = size of file on disk? 2) When insert statements are being executed, I would like to - for example - redirect the queries to another data base when 70% of the space is reached. How can I do that?
~Yuva On Dec 11, 2007 11:48 AM, Dan <[EMAIL PROTECTED]> wrote: > > On Dec 11, 2007, at 8:39 AM, Yuvaraj Athur Raghuvir wrote: > > > Hello, > > > > I am trying a simple experiment where I want to limit the size of > > the file > > that SQLite uses. Further, I want to manage the growth of the > > database(s) > > explicitly. > > > > One of the first aspects I want to manage is the size of the file > > on the > > disk. I want to set hard limits on the size and during query > > execution, on > > failures, explicitly manage the persistence across multiple > > databases (or > > disk files). > > I'm not sure I understand the second part of the question. > > Does "pragma max_page_count" (http://www.sqlite.org/pragma.html) > help any? > > Dan. > > > > > > (a) Since I am new to SQLite, I would like to hear from the > > community on how > > this can be done using what SQLite3 provides. > > > > If there are specifics that need to be managed outside the context of > > SQLite, I am fine with that. However, for doing external management I > > believe I would need hooks into the basic management of the > > database. What I > > would like to know is > > (b) are such hooks already available? > > (c) if these need to be implemented, the list of source files I > > need to look > > into will help. > > > > Thanks for your time, > > Yuva > > > > p.s: I am resending this since I am not sure if it has reached the > > mailing > > list. > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > >
