Indexing is a must to have part when it comes to the area of performance optimization from database side. However, sometimes may of us create indexes that might not be best and could have other side effects instead. From last few days of my work, I did get chance to digg a little deeper into this area and found that, there are some common techniques which we should all remember … [Read more...] about 9 Useful Mysql Indexing Tips You Should Know About
Database
Doctrine Relationship Management Between Entities
As we are using Doctrine ORM for easing our database layer programming, it's very important to understand how to establish the doctrine relationship between entities and do it in proper way to build a robust relational database design. Here by the term 'relationship', I meant the x-to-x relations, which can take form of one to one,one to many (many to one) or many to many … [Read more...] about Doctrine Relationship Management Between Entities
Transformation Between Doctrine Entity And MySQL Database
If you have started using doctrine ORM, you should already have the idea how tightly the database and doctrine entity are bonded together. Any kind of change must need to be reflected on doctrine entity and database itself as well. That can become a boring task if you start doing the changes on both side manually. So, its worth to figure out a way to migrate from one to … [Read more...] about Transformation Between Doctrine Entity And MySQL Database
How To Execute Native SQL Query With Doctrine
So, it seems like you are in big trouble. Otherwise, why will you want to execute a doctrine native SQL query? In this tutorial, I will describe and show how you can perform such operations. But that doesn't necessarily mean I am encouraging you to use it all the time. I will still strongly recommend finding your way within the doctrine's ORM, DBAL And DQL implementation as … [Read more...] about How To Execute Native SQL Query With Doctrine
Doctrine Model Plugin For Codeigniter
On an earlier tutorial, I did showed how we can easily perform the CRUD operations using doctrine ORM. However, as a lot of developers use doctrine ORM as part of their favorite Codeigntier framework, I came to feel that, it will be very useful if we can use some wrapper model for these base CRUD operations in Codeigniter, that will use doctrine implementation. This should … [Read more...] about Doctrine Model Plugin For Codeigniter