View Single Post
  #10   Spotlight this post!  
Unread 11-03-2010, 16:15
LukeS LukeS is offline
4272 mentor, 1024 alumnus
AKA: Luke Shumaker
FRC #4272
Team Role: Mentor
 
Join Date: Mar 2009
Rookie Year: 2009
Location: Indianapolis, IN
Posts: 60
LukeS is an unknown quantity at this point
Re: API for FMS twitter feed

Quote:
Originally Posted by Fletch1373 View Post
Luke, Looks like you're at the spot I was a week or so ago... I chose to switch my txt "cache" file to a mysql database for efficiency reasons

also, just out of curiosity, what do you need shell_exec for?
I basically dump semi-parsed data to stdout so I can use simple UNIX utils to add it to the existing cache, via:
PHP Code:
shell_exec("echo '".$data."' | cat - cache_file.txt | sort | uniq > cache_file.txt"); 
Quote:
Originally Posted by michandrz View Post
Luke, you finally stated to use mysql, I am shocked. oh and just to let you know it wouldn't take any of the stress off of the servers because the SQL database is on serva as well, all servb is running is NFS so serva can get to it
1) no, I didn't start useing MySQL. What gave you that impression?
2) it would take less HDD space, and not have to check for updates every minute, because it is using HTTP to get google's cache. Though, I didn't do this, I did write my own cache.