{"id":337,"date":"2014-07-10T20:43:30","date_gmt":"2014-07-11T03:43:30","guid":{"rendered":"http:\/\/layneshipley.shipley.website\/?p=337"},"modified":"2014-07-10T20:43:30","modified_gmt":"2014-07-11T03:43:30","slug":"maximum-hitsper-minute-second","status":"publish","type":"post","link":"https:\/\/layne.eqlik.us\/index.php\/archives\/337","title":{"rendered":"Maximum hits\/per minute or second"},"content":{"rendered":"

This question was recently posed one of my favorite websites (LassoSoft). \u00a0Since I’m not a paid certified developer I was unable to respond – so I’ll do it here.<\/span><\/p>\n

\u00a0<\/span><\/div>\n
“Does anyone have numbers for what maximum hits have been recorded for\u00a0FileMaker databases through the web? Whether PHP or any other\u00a0technology, or at least what can be expected (given the best possible\u00a0hardware setup)?<\/i>“<\/span><\/p>\n
\u00a0<\/span><\/div>\n
My answer is that this can very\/depend greatly base of hardware, type of request, etc. \u00a0 We run a website (www.ecodingnow.com<\/a>) on a MacMini. \u00a0 Our server has between 10,000 and 15,000 requests an hour. \u00a0Our database is hosted on the same machine as the web server (which can significantly reduce performance). \u00a0Our processor rarely rises about 5 to 7%. \u00a0Our searches are simple. \u00a0The type of data returned in a query is simple (again another factor in speed). \u00a0Because FileMaker is a single threaded database if you’re serving large images (container field kind of data) out of the system you can slow down the database down. \u00a0 Keep the data simple. \u00a0I recommend SuperContainer by 360Works to do those type of tasks (images\/files). \u00a0Apache is multi threaded so it doesn’t get hung up on those type of tasks. \u00a0Lastly, the number of records being queried can also effect speed. \u00a0Our tables contain between 75,000 to 150,000 records (no issue for speed). \u00a0I have done a database that has about 2 million records in the tables – speed was greatly reduced.<\/span><\/div>\n<\/div>\n
\u00a0<\/span><\/div>\n
PHP vs Lasso. \u00a0Overall, I’d say use Lasso if you can afford it (There are some good hosts so you don’t have to pay for a license.). \u00a0Overall speed and functionality for FileMaker as a web database Lasso wins. \u00a0 PHP is a good option just not as robust.<\/span><\/div>\n
\u00a0<\/span><\/div>\n
Overall, if done right I think you could serve millions of queries a day on FileMaker. \u00a0Most jobs FileMaker does very well. \u00a0If you use Lasso it is fairly easy to port your data to MySQL or a other SQL database. \u00a0Contrary to what many will tell you – FileMaker is a great web database if done right.<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

This question was recently posed one of my favorite websites (LassoSoft). \u00a0Since I’m not a paid certified developer I was unable to respond – so I’ll do it here. \u00a0 “Does anyone have numbers for what maximum hits have been recorded for\u00a0FileMaker databases through the web? Whether PHP or any other\u00a0technology, or at least what can be expected (given the best possible\u00a0hardware setup)?“ \u00a0 My answer is that this can very\/depend greatly base of hardware, type of request, etc. \u00a0 We run a website (www.ecodingnow.com) on a MacMini. \u00a0 Our server has between 10,000 and 15,000 requests an hour. \u00a0Our database is hosted on the same machine as the web server (which can significantly reduce performance). \u00a0Our processor rarely rises about 5 to 7%. \u00a0Our searches are simple. \u00a0The type of data returned in a query is simple (again another factor in speed). \u00a0Because FileMaker is a single threaded database if you’re serving large images (container field kind of data) out of the system you can slow down the database down. \u00a0 Keep the data simple. \u00a0I recommend SuperContainer by 360Works to do those type of tasks (images\/files). \u00a0Apache is multi threaded so it doesn’t get hung up on those type of tasks. \u00a0Lastly, the number of records being queried can also effect speed. \u00a0Our tables contain between 75,000 to 150,000 records (no issue for speed). \u00a0I have done a database that has about 2 million records in the tables – speed was greatly reduced. \u00a0 PHP vs Lasso. \u00a0Overall, I’d say use Lasso if you can afford it (There are some good hosts so you don’t have to pay for a license.). \u00a0Overall speed and functionality for FileMaker as a web database Lasso wins. \u00a0 PHP is a good option just not as robust. \u00a0 Overall, if done right I think you could serve millions of queries a day on FileMaker. \u00a0Most jobs FileMaker does very well. \u00a0If you use Lasso it is fairly easy to port your data to MySQL or a other SQL database. \u00a0Contrary to what many will tell you – FileMaker is a great web database if done right.<\/p>\n","protected":false},"author":1,"featured_media":346,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,6],"tags":[],"class_list":["post-337","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computers","category-filemaker"],"acf":[],"_links":{"self":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/comments?post=337"}],"version-history":[{"count":0,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/337\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media\/346"}],"wp:attachment":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media?parent=337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/categories?post=337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/tags?post=337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}