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]
>
> -----------------------------------------------------------------------------
>
>

Reply via email to