On Mar 8, 2007, at 5:14 PM, Andrea Gavana wrote:
>> so, its all deleted. filesize is irrelevant. > > Uhm, really? What happens if Windows is saying that the filesize is 4 > GB of empty things? I told you I know next to nothing about database, > but it seems a bit odd to me that the file size constantly increases > even if I delete things from the database... yeah definitely, its not necessarily optimal. I think it might be interesting to see if the size of the file does actually get truncated after a given amount of activity/certain threshhold of size; it is a standard methodology to "grow" a field of data as needed, but to only "shrink" it at certain intervals in the expectation that the greater size will still probably be needed in the future. but the point is, and why its "irrelvant" to me as the maintainer of SQLAlchemy, is that this is totally an issue with sqlite, and has nothing to do with SQLAlchemy. you should ask on their mailing list about this particular behavior. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
