I'm currently using PHP for a number of DB projects connecting to an MS SQL server.
(IIS 4.0, WinNT 4.0, PHP cgi, mssql_*() functions)
My next project will require the use of SQL Server's Analysis Services for data mining. I was wondering if anybody has used PHP with multi-dimensional databases (cubes), and if there are any downsides to using PHP instead of ASP. I assume that I can just query like normal (using mssql_query()), but use the multi-dimensional query language instead of SQL. If you've tackled this type of project, I would appreciate any input.
(And, on a side note, the PHP apps I'm running are much faster than similar ASP apps on the same machine (even with PHP as a CGI executable) -- hooray for PHP!)
(IIS 4.0, WinNT 4.0, PHP cgi, mssql_*() functions)
My next project will require the use of SQL Server's Analysis Services for data mining. I was wondering if anybody has used PHP with multi-dimensional databases (cubes), and if there are any downsides to using PHP instead of ASP. I assume that I can just query like normal (using mssql_query()), but use the multi-dimensional query language instead of SQL. If you've tackled this type of project, I would appreciate any input.
(And, on a side note, the PHP apps I'm running are much faster than similar ASP apps on the same machine (even with PHP as a CGI executable) -- hooray for PHP!)