事务是否足以在基于codeigniter 3.x的应用程序中同时处理数千或数百万个请求？

Is implenting transaction in codeigniter enought to handle simultaneous thousands or even millions of requests at the same time? like e.g in my model like this

transaction begin insert data in table one. insert data in table two commit esle if failed rollback