Please forgive me if this has already been answered, I have read the FAQ, but it’s hard to get an exact understanding on this. I did read where it looks like Piwik use zend_db? Would that mean that the SQL that is generated is abstracted to this layer? Or is the SQL (dynamic) tightly coupled and scattered throughout the code with MySql syntax?
The reason I’m asking is because we use SQL Server 2008 and have our DB Servers setup to handle a large number of transactions. But since Piwik is constrained to only run on MySql I feel that I will not be able to get the performance out of it, because they won’t let me setup MySql on our DataBase servers. I could set it up on the webserver I was going to install Piwik on, but I’m not sure it will perform enough. We currently have over 45 million page views a month with a couple of our site, so performance would be a factor. If I could figure out from the source code, how the SQL Statements are built and where the connections are taking place I might be able to change it use a Microsoft SQL Server 2008 database.