(John Lim) This article focuses on a rather difficult topic – understanding the performance characteristics of PHP. It is difficult, not because PHP is complex, but because PHP’s performance depends on many outside factors such as software versions, available hardware, operating system settings,
Other News
Stored Procedures on PHP and Microsoft SQL Server
(David Clark) Though it’s not as common a combination as PHP and MySQL, PHP and Microsoft SQL Server can be a powerful team. You can query SQL Server databases easily and effectively using the PEAR database abstraction layer, just as you would a MySQL database. But once you start trying to use one o
Access queries with a wildcard character do not export data to an XML document
When you export an Access query to an XML document, and the query contains a Microsoft Jet wildcard character such as an asterisk (*) in the criteria, the data is not exported to the XML document. Therefore, the resultant XML document does not contain any data. The query functions correctly if yo
Are You Ready for the ACID Test?
(Christopher Byrne) Though Lotus Notes/Domino developers and administrators may think that someone on mind-altering substances created relational database concepts relating to systems controls, I am not talking about The Electric Kool-Aid Acid Test, made famous by Tom Wolfe in the 1960s. And I do no
Essential Facts about Index Covering in DB2 Universal Database
(Alexander Kuznetsov) This article uses examples to illustrate cases in which adding a column or two to an index can boost a query’s performance by “covering” the columns used in a SELECT statement. The DB2 optimizer is very good in recognizing such situations and can choose a very efficient executi
Disaster Recovery with DB2 UDB for z/OS
(Paolo Bruni) DB2 for z/OS is the database of choice for critical data for many enterprises. It is becoming more and more important to protect this data in case of disaster and to be able to restart with a consistent copy of the DB2 data as quick as possible and with minimal losses. A broad rang
Monitor Blocking in SQL Server 2000 – Part 1
(Muthusamy Anantha Kumar) Part of Database Administrator’s job is to monitor blocking in SQL Server. By taking advantage of the Microsoft Knowledge Base article 271509, we can monitor the blocking and capture the SQL statements that are involved in the blocking to a file. This can be accomplished by
Comparing the Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NET
(Bill Hamilton) Get a comparison of the strengths of the two most common .NET data providers for Oracle, and be prepared to select the right one for your next development project.
Format Your Way to Success with the .NET Framework Versions 1.1 and 2.0
(Juval Lowy) Serialization is the act of persisting the state of an object, typically to a file or a memory stream. Serialization is crucial when it comes to composing an application out of independent components. If an application contains several components from various vendors, how will it persis
Changing Databases at the Customer’s Location Using XML and VB
(Dinesh Asanka) As a database developer, you may be fed up with never-ending customer changes. Actually, this is not only relevant to database developers but also for all other developers. But, because database developers have to meet customer requirements, they may need to change the databases.