4 key distinctions of the new IBProvider v3.4 that make your applications faster

4 key distinctions of the new IBProvider v3.4 that make your applications faster:

Firebird driver become faster

  1. Possibility to abort lengthy loading of resulting rowsets in SQL scripts.
  2. Control and adjustment at your own discretion of deferred data loading.
  3. Accelerated work with BLOB fields and arrays in updatable rowsets.
  4. Background garbage collector became multithreaded.

Please read details here: Firebird driver become faster

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

django-firebird switched for #django 1.2/1.3 support only in svn trunk

The django-firebird trunk was updated with new version. It supports django 1.2 and I hope what support the next 1.3 release too.

I was using this version on production web app and all work fine for
now.[ED:also firebirdsql.ro works ok with it]

The prior django-firebird implementation with support for django 1.1 was tagged

Please, feel free to check it out and report any issue.
Any feedback is wellcome.

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Firebird 2.1.3 #HDD vs #SSD Benchmarks

The forum post with the results are in Spanish but here are the results and translation in English:
1. The computer was as below :

  • Intel Core i7 930 2.93 @ 4.0 Ghz
  • 6GB DDR3 1600 Cas 7
  • Mobo Gigabyte x58-UD3R
  • Professional 64-bit Windows 7
  • Firebird 2.1.3
  • 2. Hard Drives :
    a. Western Digital 1TB 64MB Cache Sata III Black
    b. Crucial 128GB RealSSD C300

    The test consisted in the creation of a database with 1 table :

    CREATE TABLE COR_PRUEBA (
    INTEGER INTEGER NOT NULL,
    CHARACTER CHAR (20),
    CARACTER2 CHAR (10),
    “DOUBLE” DECIMAL (15, 2),
    INTEGER1 INTEGER);
    ALTER TABLE COR_PRUEBA
    PK_COR_PRUEBA ADD CONSTRAINT PRIMARY KEY (INT);

    The test is done with the IBExpert 2009.08.19 and consisted of the insertion of 500,000 records (Insert operations) with random data.
    Results:

    Disc A (HDD): 1hr 11m 40s 43ms
    Disc B (SSD): 3m 42s 224ms

    What really stunned me was the Big difference and both tests were performed with exactly the same parameters.
    Judge yourself whether it is worth mounting a SSD for storage xD.

    1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 4.20 out of 5)
    Loading...

    Firebirdsql website down – do not panic

    Please do not panic , the line upgrade went wrong so it will be soon fixed

    Message from Helen :

    >I will put SQL script into rabbit hole tomorrow (provided WEB server
    >will be alife). Currently non of new/old IPs do not ping.

    Message from Sean indicates things went wrong with the migration to the new subnet of the hosting provider. The current situation is that the Tracker is up, while the webserver is not serving pages. Can’t give more info at present as Sean is not at his desk today.

    1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 5.00 out of 5)
    Loading...

    1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
    Loading...

    1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
    Loading...

    Tips : create/alter/drop user in firebird 2.5 , or howto get rid of gsec

    On .net provider list Rick Roen is writing a utility to change user password , the best way to change it is from sql :).
    Read the user create/delete/update notes.
    Now a regular user can change it’s own password without the need for sysdba intervention:

    The new DDL command ALTER USER enables an “ordinary” user (a regular Firebird user, a non-root user on POSIX or a trusted user on a Windows system where trusted authentication is enabled) the ability to change his or her password and/or personal name elements, while logged in to any database.

    1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
    Loading...

    1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
    Loading...

    Database trends survey (Embarcadero)

    Marco Cantu posted in his blog:

    …While most of the questions are on the choice and number of servers used (MS SQL Server being the most widely adopted, Oracle the most critical, and Firebird has a significant 4% 5.5% presence for large companies). Other questions are tuned for Embarcadero products (like evaluating the need for automating some DBA tasks). A few questions are interesting for their broad perspective, like those focused on the relationship between developers and DBAs…

    Btw, interesting that there is no mention of Embarcadero’s Interbase in the survey results.

    1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
    Loading...

    1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
    Loading...

    1 … 229 230 231 232 233 … 495