[sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

Hi There, 1) We are trying to use sqlite3 in Glusterfs as a Change Time Recording Data Store i.e using sqlite3 db to record any modification attempts that happens on the glusterfs per file inode, So that it can be used to indicate the hotness of the file in the cluster. 2) We have developed a

Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

Your Glusterfs does not store modification times? Have you considered adding the modification time attribute to the inode directly? --- Theory is when you know everything but nothing works. Practice is when everything works but no one knows why. Sometimes theory and practice are combined:

Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

As any Filesystem glusterfs also has a atime,mtime and ctime. But we are trying to optimize the search of file that are "HOT" or "COLD" using sqlite3, As a filesystem walk would kill the scanners(which are doing data maintenance) ~Joe - Original Message - From: "Keith Medcalf"

Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

On Fri, 21 Nov 2014 14:01:39 -0500 (EST) Joseph Fernandes wrote: > Hi There, > > 1) We are trying to use sqlite3 in Glusterfs as a Change Time > Recording Data Store i.e using sqlite3 db to record any modification > attempts that happens on the glusterfs per file inode, So

Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

Thanks Eduardo. Answers inline JOE>> - Original Message - From: "Eduardo Morras" To: sqlite-users@sqlite.org Sent: Saturday, November 22, 2014 9:20:46 PM Subject: Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs On Fri, 21 Nov 2014

Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

On Fri, 21 Nov 2014 14:01:39 -0500 (EST) Joseph Fernandes wrote: > 4) Therefore, we are looking at a datastore that can give us a very > quick write(almost zero latency, as the recording is done inline > w.r.t file IO) and that as good data querying facilities(Slight >

Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs

Thanks James Please find the answers inline JOE>> - Original Message - From: "James K. Lowden" To: sqlite-users@sqlite.org Sent: Saturday, November 22, 2014 10:29:01 PM Subject: Re: [sqlite] Using Sqlite3 as a Change Time Recording Data Store in Glusterfs On