CodeIgniter Forums
Handling 10,000 concurrent users - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Handling 10,000 concurrent users (/showthread.php?tid=16086)

Pages: 1 2


Handling 10,000 concurrent users - El Forum - 02-24-2009

[eluser]Relexx[/eluser]
I don't know what database you are using, or if you are using one, but with 10,000 concurrent users data concurrency could be an issue.


Handling 10,000 concurrent users - El Forum - 02-24-2009

[eluser]ravi kiran[/eluser]
Hi Relexx,
I am planning to use mysql.


Handling 10,000 concurrent users - El Forum - 02-24-2009

[eluser]Relexx[/eluser]
Then you need to understand how mysql handles concurrent updates, deletes. 10,000 users, I assume, will significantly increase the chance of the same records being updated. You definitly want to be looking an InnoDB or Falcon (if using Mysql6).

InnoDB
InnoDB storage Engine
in particular
- Transaction model
- Multi-versioning

Falcon
Falcon Storage Engine

If you are storing credit card details you need to consider standards such as PCIDSS


Handling 10,000 concurrent users - El Forum - 02-24-2009

[eluser]ravi kiran[/eluser]
I am guessing..problem wouldnt be with updates..this site we are planning is mainly about retrieving data..so majority u can say 80% of the users use it to retrieve data


Handling 10,000 concurrent users - El Forum - 02-25-2009

[eluser]ravi kiran[/eluser]
To be exact this will be a business listing directory