The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,685 other followers

Archive for January 18th, 2013

Firebird and InterBase have single direction indexes for your data safety.

Posted by jpluimers on 2013/01/18

In most database index nodes are doubly linked to allow bi-directional scans. http://is.gd/8CMb7w, however not for InterBase and FireBird, there the reverse link isn’t used because it can be inconsistent due to write order of index pages.

The result is that in Firebird and InterBase, indexes are single-directional (either ascending or descending).

This is for your safety: it guarantees index consistency, even if because of EMP, your machine suddenly reboots after your tank fired a missile.

–jeroen

via Twitter / Avalanche1979: @SQLPerfTips For Firebird the ….

(Wow, did I really wrote 1200 blog posts?)

Posted in Database Development, DB2, Development, Firebird, InterBase, MySQL, OracleDB, PostgreSQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 7, Sybase | Leave a Comment »

Dell Dimension 9200/DXP061: 8GB is possible (via: Type of memory for Dimension 9200/DXP061 – Tech Support Guy Forums)

Posted by jpluimers on 2013/01/18

Though my Dell Dimension 9200/DXP061 machines already had 4 gigabyte of memory, I just learned they can go to 8 gigabyte of memory.

Multiple source confirm that it is possible to put 8 GB of memory in a Dell Dimension 9200/DXP061 (aka “Dell XPS 410”):

–jeroen

Posted in Hardware, Power User | Leave a Comment »

 
%d bloggers like this: