A for instance, from a client app:
mysql> select count(*) as number_of_tables from information_schema.tables where table_schema = 'cake_app';
+------------------+
| number_of_tables |
+------------------+
| 444 |
+------------------+
1 row in set (12.43 sec)
So that's a 444 Table app (has 444 models). Some record counts:
mysql> select count(*) from contacts;
+----------+
| count(*) |
+----------+
| 2626399 |
+----------+
1 row in set (0.59 sec)
mysql> select count(*) from campaign_segments_contacts;
+----------+
| count(*) |
+----------+
| 3640545 |
+----------+
1 row in set (0.65 sec)
mysql> select count(*) from activities;
+----------+
| count(*) |
+----------+
| 11954349 |
+----------+
1 row in set (0.89 sec)
mysql> select count(*) from activity_attributes;
+----------+
| count(*) |
+----------+
| 73085817 |
+----------+
1 row in set (12.46 sec)
See? Rocking a Cake App with over 70 million records in some tables! ;)
Keith wrote:
I've not found MVC frameworks to scale well regardless of the one you pick. Knowing how many records you've got isn't all that helpful either because it's how you interact with them that affects performance.
--
-MI
| Coding Ninja @ CRICAVA Technologies | |
| Blog: | http://www.marianoiglesias.com.ar |
| Twitter: | http://twitter.com/mgiglesias |
| LinkedIn: | http://www.linkedin.com/pub/2/483/B94 |
| Facebook: | http://www.facebook.com/mariano.iglesias |
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
No comments:
Post a Comment