Sponsored Content
The Lounge What is on Your Mind? Bits Under Development: Forum Activity Index (FAI) Post 302328852 by Neo on Thursday 25th of June 2009 10:20:47 AM
Old 06-25-2009
Quote:
Originally Posted by Neo
One idea I had is to simply change the algorithm where

Code:
FAI(2) =   Bits in Circulation (Activity within 2 Years) / Number of Posts (In the Past 2 years)

Or:


Making it the "Two Year FAI" ..... or something along those likes.
OK, for the time being, I made the change above, which translates to (for those who care about the technical details):

Code:
$fai2_posts = $db->query_first('SELECT COUNT(*) AS total FROM ' . TABLE_PREFIX . 'post WHERE dateline > (UNIX_TIMESTAMP() - (60 * 60 * 24 * 365 * 2))');

I think I'll add one for one year as well, maybe the FAI(1) Smilie
 

7 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

why the inode index of file system starts from 1 unlike array index(0)

why do inode indices starts from 1 unlike array indexes which starts from 0 its a question from "the design of unix operating system" of maurice j bach id be glad if i get to know the answer quickly :) (0 Replies)
Discussion started by: sairamdevotee
0 Replies

2. UNIX for Dummies Questions & Answers

wh inode index starts from 1 unlike array index (0)

brothers why inode index starts from 1 unlike array inex which starts from 0 its a question from the design of unix operating system of maurice j.bach i need to know the answer urgently...someone help please (1 Reply)
Discussion started by: sairamdevotee
1 Replies

3. Shell Programming and Scripting

Sort from start index and end index in line

Hi All, I have a file (FileNames.txt) which contains the following data in it. $ cat FileNames.txt MYFILE17XXX208Sep191307.csv MYFILE19XXX208Sep192124.csv MYFILE20XXX208Sep192418.csv MYFILE22XXX208Sep193234.csv MYFILE21XXX208Sep193018.csv MYFILE24XXX208Sep194053.csv... (5 Replies)
Discussion started by: krish_indus
5 Replies

4. What is on Your Mind?

What exactly is the concept of BITS in this unix.com forum?

Is there a detailed page on the explanation of concept behind BITS and score used in this forum. Just saw the index on my Banking page. (Clicked the Banking hyperlink below my profile name on the topmost right corner of this screen) Thanks in advance. (2 Replies)
Discussion started by: Manjunath B
2 Replies

5. What is on Your Mind?

Place Bits & Win Bits!!! - 17th Annual Satellite Awards

Ten movies have been nominated as best motion picture by the International Press Academy, presentation of the 2012 Satellite Awards will be held on 16th December at Los Angeles, CA. Place your bits here on one of the below nominated movie of your choice:- Argo ... (0 Replies)
Discussion started by: Yoda
0 Replies

6. What is on Your Mind?

Updated Forum Search Index Min Word Length (Again)

For some reason, three char word lengths were not showing up in search results, even though the minimum is set to three and has been for a long time. After monkeying around with this, I turned off full page search, dumped all search indexes, and re-enabled full text search and it's working... (1 Reply)
Discussion started by: Neo
1 Replies

7. What is on Your Mind?

Updated Forum Search Index Min Word Length to 2 Chars and Added Quick Search Bar

Today I changed the forum mysql database to permit 2 letter searches: ft_min_word_len=2 I rebuilt the mysql search indexes as well. Then, I added a "quick search bar" at the top of each page. I have tested this and two letter searches are working; but it's not perfect,... (1 Reply)
Discussion started by: Neo
1 Replies
MTBL_INFO(1)															      MTBL_INFO(1)

NAME
mtbl_info - display information about an MTBL file SYNOPSIS
mtbl_info FILE [FILE]... DESCRIPTION
mtbl_info(1) displays the following information about the MTBL files specified on the command line. file name -- the name of the MTBL file. file size -- the total size of the MTBL file, in bytes. index bytes -- the total number of bytes and proportion of the total file size consumed by the index. data block bytes -- the total number of bytes and proportion of the total file size consumed by data blocks. data block size -- the maximum size of an uncompressed data block. data block count -- the total number of data blocks. entry count -- the total number of key-value entries. key bytes -- the total number of bytes that all keys in the file would occupy if stored end-to-end in a byte array with no delimiters. value bytes -- the total number of bytes that all values in the file would occupy if stored end-to-end in a byte array with no delimiters. compression algorithm -- the algorithm used to compress data blocks. Possible values are "none", "snappy" and "zlib". compactness -- a rough metric comparing the total number of bytes in the key-value entries with the total size of the MTBL file. It is calculated as (file size) / (key bytes + value bytes), and thus takes into account the gains of data block compression and prefix key compression against the overhead of the index, trailer, and data block offset arrays. 05/29/2012 MTBL_INFO(1)
All times are GMT -4. The time now is 09:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy