Is there a way to programatically clear the buffer cache on the Mac, preferrably in C? Basically, I'm looking for the source of 10.5's purge command. EDIT: I now see this is part of the CHUD tools, for which it seems the source isn't directly available. However, I'm still looking for some code to do the same. ...
Right - I want to delete (e.g.) 1,000,000 records from a database. This takes a long time -> the transaction times out and fails. So - I delete them in batches say 25000 records per transaction. Using the limit clause on MySQL or ROWNUM on Oracle. Great this works. I want to do this in a database indepedent way. And from an existing Jav...
We have a mature Oracle database application (in production for over 10 years), and during that time, we have been using scripts of our own devising to remove old data that is no longer needed. They work by issuing delete statements against the appropriate tables, in a loop with frequent commits, in order to avoid overloading the system...
Does SVN allow you to completely and cleanly delete an entire revision from its folder structure? I used Tortoise SVN to delete a file from the SVN repository, and due to size I want it to be completely removed from the repository. It appears to be deleted from the head revision, but not from the SVN folder structure. I would like ...
iPhone SDK question: Does anyone have suggestions on how to purge a cached UITableViewCell I'd like to cache these cells with reuseIdentifier. However, there are times when I need to delete or modify some of the table rows. I expect to call reloadData after the row changes. Right now, dequeueReusableCellWithIdentifier always returns th...
I have a pair of bash scripts, 1 that dumps mysql dbs, and the second to purge old backups. I have always relied on date, so any files older than 7 days are purged, and new backups created daily. The result was a set of backups 7 days back. Well now that I have 20+ dbs I have separated that daily job into a daily, and weekly job. If I...
If I see an email returned due to a hard bounce, after how many days is it acceptable to resend to that email address. It is possible for emails to be reactivated or for temporary outages, so it doesn't make sense to keep an email in my hard bounce email list forever. I've already seen cases where I receive emails from addresses that wer...
Is it OK to truncate tables while at the same time using Hibernate to insert data? We parse a big XML file with many relationships into Hibernate POJO's and persist to the DB. We are now planning on purging existing data at certain points in time by truncating the tables. Is this OK? It seems to work fine. We don't use Hibernate's s...
i am getting the purge to work on a queue but not on its journal any idea why? MessageQueue oque1 = new MessageQueue(Qname); oque1.UseJournalQueue = true; oque1.Purge(); ...
I want to purge the ibdata1, ib_logfile0 and ib_logfile1 files in MySQL. Because these files are taking too much space of my C:\ disk. And I don't want to move these files anywhere else in the Hard disk. I heard about purging which can shrink the data. I am using Windows Vista. What are the steps to be done to purge the data ? ...