RAID 10 performance tradeoffs and firebird

I have been configuring a fair number of Linux database servers for a line-of-business application; it runs the Firebird SQL database in server mode only (no application code at all – just DB).

All of these are the wonderful Dell PowerEdge 2950 units with the PERC6i RAID controller, and my typical configuration is 6x 146G 15k SAS drives. These are the highest-performance, highest capacity solution in 3.5″ drives.

(No Ratings Yet)

(No Ratings Yet)

(No Ratings Yet)

(No Ratings Yet)

Python, kinterbasdb and 64bit MacOSX 10.5

Now we have 64bit builds of Firebird 2.1 for MacOSX 10.5, we have issues trying to test them properly using the Firebird QMTest QA suite. This QA suite relies on Python and kinterbasdb. Currently Philippe Makowski has been able to run the tests from a 64bit Linux client. But is unable to run the tests locally. Well currently the python framework that comes with MacOSX 10.5 is only 32bit and this forces a 32bit build of kinterbasdb, since the build environment of kinterbasdb uses distutils to use the same compile switches as python. So I thought I would have a look at the issue and see if I could build a 64bit version of kinterbasdb for MacOSX 10.5.

This is how I did it…

(No Ratings Yet)

(No Ratings Yet)

AnySQL Maestro released

AnySQL Maestro SQL Maestro Group announces the release of AnySQL Maestro – a freeware, but powerful tool for all the database engines accessible via ODBC driver or OLE DB provider (Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, etc). Key features include database object management, graphical database designer, visual query builder, data export and import, BLOB Viewer/Editor, and a lot of other things.

AnySQL Maestro has been successfully tested with Firebird ODBC drivers 1.xx and 2.0 beta and all the latest Firebird server versions up to 2.1.

(No Ratings Yet)

(No Ratings Yet)

(No Ratings Yet)

Integration Services, Part 1 – Import and data processing in Firebird and Interbase

SQL Server Integration Services (SSIS) – is a comfortable way for developing ETL processes. Integrations Services Projects are well integrated with other development tools of SQL Server 2005 – Analysis Services (SSAS) and Reporting Services (SSRS). Excel workbooks, text and XML files as well as databases with OLE DB Provider realization may be both data sources and data receivers. To work with Firebird и Interbase data в Integration Services you should use OLE DB Source and OLE DB Destination Components. Also you should install IBProvider Professional Edition.

Read full article.

(2 votes, average: 1.50 out of 5)

1 … 355 356 357 358 359 … 495