2. PHPRunner General questions
  3. PHPRunner and MYSQL Limits
This topic is locked

PHPRunner and MYSQL Limits

 		11/9/2013 1:18:57 PM
PHPRunner General questions
D
 DUKE author

Hi Everyone,
What are the practical limits of PHPRunner and MYSQL?
I have been asked to start work on a database that will contain between 10 000 and 20 000 records.
A separate table will be used as a document library to store scanned .PDF documentation.
We might look at 30 000 documents that will be stored eventually.
My questions are:
Will PHPRunner and MYSQL handle something like this?
Has anyone here built a database of this size?
I will start out with the project on my dedicated server along with all of my other domains and sites.
Eventually, (depending on traffic etc...) the project will be moved over to its own dedicated server.
Sergey Kornilov admin 11/9/2013

30,000 records is nowhere close to MySQL limits and PHPRunner itself adds very little overhead.
In this article we have tested PHPRunner with MySQL database containing 12 million records (registered Florida voters):

http://xlinesoft.com/blog/2011/04/08/improving-perfomance-of-phprunnerasprunnerpro-applications/

After adding proper indexes we made pages load in under one second.
HJB 11/10/2013

Citing ex July 2012 published WHITE PAPER by ORACLE and INTEL on My SQL Cluster 7.1 testing, headlined "1 Billion Writes per Minute", Quote excerpt: Running the tests from Oracle and Intel, MySQL Cluster delivered: - 4.3 Billion fully consistent reads (SELECTs) per minute - 1.2 Billion fully transactional writes (UPDATEs) per Minute unquote