stargeek
PHP news website logo.
home    PHP scripts    articles    seo tools    links    search    contact    shop    realtors


Linux Database Benchmarks







Linux Database Benchmarks

Linux Database Benchmarks 12/31/2004 08:53 PM

SQLite Database Speed Comparison: If you ever wanted to know which Linux database option was the fastest, the guys over at SQLite have done some tests. No surprises: SQLite wins, MySQL is second, with PostgreSQL trailing the pack.

Note to Access users: MySQL can do 25,000 inserts in two seconds. SQLite can do it in less than one second. While Access is great for desktop work, I shudder to think how it would stack up in this test.

I'd be interested to see where Firebird fits in this scale.




This is a GrokNews Entry: (what is grok?)





Similar Items

Linux Database Benchmarks

Grok Headline matches for Linux Database Benchmarks

Linux Gains New Server Benchmarks


Linux Gains New Server Benchmarks 03/20/2003 01:05 PM
The Open Source Development Lab, a group sponsored by IBM, Toshiba, Ericsson, HP, SuSE and Red Hat, has released software that enables Linux developers to perform three commonly used benchmark tests for free. Veteran Linux industry watchers expect the move will help speed Linux development.

Linux on iMac G5 benchmarks show 35%
speed boost


Linux on iMac G5 benchmarks show 35%
speed boost
09/24/2004 09:53 PM

Linux Journal: Making a PHP Site on
Linux Work with a Microsoft SQL Server
Database


Linux Journal: Making a PHP Site on
Linux Work with a Microsoft SQL Server
Database
02/17/2003 09:09 AM
"It's a LAMP site, but the M isn't MySQL. Can PHP on the Linux box make the connection to Microsoft SQL Server?"

McObject’s eXtremeDB - First In-Memory
Database for BlueCat Linux 5.0 and Linux
2.6 Kernel


McObject’s eXtremeDB - First In-Memory
Database for BlueCat Linux 5.0 and Linux
2.6 Kernel
06/22/2004 02:43 AM
With McObject’s release of its eXtremeDB 2.3 in-memory embedded database for LynuxWorks’ BlueCat Linux 5.0 operating system, developers of embedded Linux applications for the first time have an in-memory database system (IMDS) available for LynuxWorks’ powerful embedded platform, and for the Linux 2.6 kernel on which BlueCat Linux 5.0 is based. [PRWEB Jun 22, 2004]

Benchmarks? We don't need no stinking
benchmarks...


Benchmarks? We don't need no stinking
benchmarks...
04/01/2005 09:09 AM
Insi de the Pentagon.  Hilarious. News is finally leaking out how the US warplan for Iraq lacked (until recently) specific benchmarks.  Rapid changes in course can be characterized as flexibility if those changes are slaved to defined objectives.  If those objectives don't exist, it's chaos.

Of course, these new benchmarks are classified.  This means that they are effectively useless in this conflict.  In order to fight a decentralized insurgency, decision making must be pushed down to the lowest levels.  Every soldier in Iraq should know what these objectives are so they can adapt their effort to accomplish them.

The top U.S. officer in Iraq, Army Gen. George Casey, lately has been garnering plaudits behind the scenes from his military and civilian colleagues for adding measurable benchmarks to his campaign plan, a classified document in which a commander typically delineates security objectives and how subordinate units will attain them. But some officials say the nearly two-year delay in laying out clear and realistic security goals in a single military plan has taken a toll on the Iraqi stability and reconstruction effort.

Charge rates database for Linux


Charge rates database for Linux 02/12/2004 07:32 PM
rate-de-eur (rate-de.dat) 3.08

Linux Hardware Database Unification


Linux Hardware Database Unification 07/01/2004 03:57 AM
First Release of LinuxHard

Sybase Offering Flagship Database For
Linux


Sybase Offering Flagship Database For
Linux
09/08/2004 04:23 PM
Hot on the heels of IBM and CA, Sybase is giving away a limited version of its flagship database for Linux users, with a twist.

Sybase releases free database for Linux


Sybase releases free database for Linux 09/09/2004 11:12 AM
Company goes head-to-head with MySQL and PostgreSQL with a free version of its ASE database for Linux.

Sybase Offers Free Linux Database


Sybase Offers Free Linux Database 09/09/2004 04:46 PM
Sybase is offering a free version of its leading enterprise database management system for Linux.

IBM Releases New Linux-Oriented Database
Software (Reuters)


IBM Releases New Linux-Oriented Database
Software (Reuters)
09/09/2004 08:44 AM
Reuters - International Business Machines Corp. late on Wednesday rolled out a new version of its database software aimed at users of Linux and Unix operating systems that it hopes will help the company take away market share from market leader Oracle Corp. .

Sybase Releases Free Enterprise Database
on Linux


Sybase Releases Free Enterprise Database
on Linux
09/09/2004 05:27 AM

Sybase Offers Free Database for Linux
(PC World)


Sybase Offers Free Database for Linux
(PC World)
09/09/2004 08:44 AM
PC World - Company hopes to attract users who will later upgrade to its small business software.

MySQL voted best database by Linux
Magazine editors


MySQL voted best database by Linux
Magazine editors
06/12/2002 06:22 AM
MySQL is the best and most popular Linux database according to the editors of Linux Magazine. MySQL is rewarded the year 2000 Tuxie award for it's speed, reliability and ease of use. The editors are also pleased with MySQL being released under the GPL license in June 2000.

Sybase releases free Express database
for Linux


Sybase releases free Express database
for Linux
09/08/2004 01:00 PM
In a bid to expand the customer base for its database software, Sybase Inc. released on Tuesday a free, limited version of its software for deployment on Linux systems.

Computer Associates adopts Linux for
Ingres database


Computer Associates adopts Linux for
Ingres database
05/31/2004 12:37 PM
The New Zealand Herald May 31 2004 5:14PM GMT

Linux biggest gainer in relational
database market


Linux biggest gainer in relational
database market
05/28/2004 10:51 AM
ZDNet UK May 28 2004 3:48PM GMT

MySQL voted "favorite database" by Linux
journal


MySQL voted "favorite database" by Linux
journal
06/12/2002 06:22 AM
MySQL got the "Readers Choice award as "Favorite database" by Linux journal, January 2000

Gartner: IBM tops database market, but
Oracle leads in Linux


Gartner: IBM tops database market, but
Oracle leads in Linux
05/27/2004 05:01 PM
Gartner Inc. reported that annual database sales rose by just over 5% last year, from $6.7 billion in 2002 to almost $7.1 billion. But much of that increase was due to changes in currency values, not higher demand.

Sybase Offers Free Linux Database (Ziff
Davis)


Sybase Offers Free Linux Database (Ziff
Davis)
09/09/2004 06:44 PM
Ziff Davis - Sybase is offering a free version of its leading enterprise database management system for Linux.

Sybase releases free top-of-the-line
database for Linux systems


Sybase releases free top-of-the-line
database for Linux systems
09/09/2004 04:17 PM
Dublin, Calif.-based Sybase, the veteran IT company best known for PowerBuilder and a score of middleware products, has joined a growing list of companies in releasing open source databases and other software to lure more customers to their premium products. To the company's credit, it is not releasing a second-hand piece of software, as IBM did last month with Cloudscape, a leftover from the Informix catalog.

Making a PHP Site on Linux Work with a
Microsoft SQL Server Database


Making a PHP Site on Linux Work with a
Microsoft SQL Server Database
02/14/2003 10:43 AM
It's a LAMP site, but the M isn't MySQL. Can PHP on the Linux box make the connection to Microsoft SQL Server?

Gartner: Database Market Stable, With
High Linux Hot Spot (TechWeb)


Gartner: Database Market Stable, With
High Linux Hot Spot (TechWeb)
05/27/2004 03:07 AM
TechWeb - Gartner Dataquest numbers show a nearly flat market for relational databases and huge gains in Linux RDBMS markets.

First DBX Benchmarks


First DBX Benchmarks 02/05/2003 12:19 PM
Excellent! John Lim did some benchmarking with ADOdb and DBX. Before this, I was a bit worried that the reason people are not using DBX is because it is slow. We now have some proof that it isn't. Now we know that there is no technical reason not to position DBX as a standard PHP DB wrapper.

Firebird Database Remote Database Name
Overflow


Firebird Database Remote Database Name
Overflow
06/01/2004 03:27 PM
Aviram Jenik (Jun 01 2004)

Unofficial ATI R4++ Benchmarks


Unofficial ATI R4++ Benchmarks 04/23/2004 08:33 PM

Geforce 6 Go Benchmarks


Geforce 6 Go Benchmarks 09/12/2004 04:25 PM

phpEverywhere: More About the Benchmarks


phpEverywhere: More About the Benchmarks 11/19/2003 09:18 AM
A little while back, we mentioned some of the benchmarking that phpEverywhere was doing with one of the new suites, and now, with some solid results behind them, they've posted a graph of the results.

New TPC benchmarks are on the horizon


New TPC benchmarks are on the horizon 09/21/2004 08:14 AM
Computer Business Review Sep 21 2004 12:44PM GMT

iMac G5 Benchmarks


iMac G5 Benchmarks 09/24/2004 06:23 PM
By James Galbraith, Macworld (via MyAppleMenu)

Breaking Down The Benchmarks


Breaking Down The Benchmarks 09/22/2004 06:17 PM
By James Galbraith, Macworld (via MyAppleMenu)

Interactive Benchmarks


Interactive Benchmarks 07/11/2004 08:38 AM

AMD A64 90nm Benchmarks


AMD A64 90nm Benchmarks 07/11/2004 06:35 AM

Parser benchmarks


Parser benchmarks 05/14/2004 03:25 PM

And finally I end this marathon blogging session with another one of our PeepAgg team members - Chris Schmidt.

Chris did the FOAF module for LiveJournal and is now working on getting PeepAgg into Drupal.

:-)

Here's his post....

ApacheBe nch testing of XML Parsing. So, I've been working on a project called PeopleAggregator, and we've been talking about integrating with a lot of different platforms, among them Drupal. (For the record, this is completely unrelated to the MT stuff that went on today. I may write on that later, but really, everyone else has said what I would in a million different ways.) Anyway, we were talking about RAP and how it's too bulky and slow to work for what we need.

So, we got a guy on the team - Joel De Gan, who's working on the PeoplesDNS project for us, and he offered to write us a parser. This is going to be a replacement for RAP, for those of us who can't deal with the slowness of RAP.

Now, I don't know much about RAP. And I don't know much about PHP, or parsing XML, or really anything - I pick up the bits I need to know as I go along. So I'm just kind of standing on the sidelines, but today, I got a demo of what Joel's parser can do.

LiveJournal FOAF files are typically big. Mine is no exception - over 100 friends, random contact data, etc. All in all, a 40KB document about me. I want to parse this data. So I attempt to using both RAP and Joel's parser.

To alleviate network traffic conditions, I copy the file I want locally. To simulate the action of opening a file and reading it, I did keep it on the webserver, so I will admit there may be some kind of bias in that, but I used the exact same method to open the file in both cases (fopen) so I don't think that's an issue that would cause any major difference. I also disabled all printed output.

Anyway, I used this file to check the parsers. Using ab (apache benchmarking utility - fetches a page a bunch of times and tells you how long it took). Using a 50 request check, I got averages on the two parsing utilities:

Joel De Gan's XML parser, parses data into a multileveled array as displayed at http://crschmidt.net/parse/ parse.php (source available):

Requests per second: 11.25 [#/sec] (mean)
Time per request: 88.92 [ms] (mean)
Time per request: 88.92 [ms] (mean, across all concurrent requests)

(Full Stats)

RAP, parses into RDF models. (source, + RAP. The parser isn't actually here):

Requests per second: 1.35 [#/sec] (mean)
Time per request: 739.82 [ms] (mean)
Time per request: 739.82 [ms] (mean, across all concurrent requests)

(Full Stats)

So, we've got a parser that to a guy like me seems simpler to use (advanced data structures are part of the limited experience I did get from LiveJournal), is lightweight (one file, as opposed to 256 in RAP), and faster by an order of magnitude.

That, to me, sounds like a winner. Props to Joel for his great work. His next step is to implement OWL capabilities into RDF parsing, and that's going to kick even more ass. As Eric said at one point about this: "Be still my beating heart." By crschmidt@livejournal.com. [Christopher Schmidt]


Hyperthreading Benchmarks


Hyperthreading Benchmarks 01/13/2003 03:51 AM
There's an excellent article on IBM DeveloperWorks that presents a performance analysis of the 2.4 and 2.5 kernel's hyperthreading support. Good stuff. I look forward to the enhanced scheduler in 2.5. Perhaps it's one of the few reasons we need...

iMac 1.8 Ghz G5 Benchmarks


iMac 1.8 Ghz G5 Benchmarks 09/15/2004 03:47 PM
Thanks to one of our readers, we have some early benchmark results on a 20" 1.8 Ghz G5 iMac. Cinebench results:CINEBENCH 2003 v1 *******************...

First GeForceFX 5700 GO benchmarks!


First GeForceFX 5700 GO benchmarks! 11/10/2003 11:34 PM

MySQL Benchmarks on a Dual G5?


MySQL Benchmarks on a Dual G5? 10/31/2003 07:27 PM

ATI R420 Benchmarks Leaked


ATI R420 Benchmarks Leaked 05/03/2004 06:13 PM

Grok Description matches for Linux Database Benchmarks
GrokA matches for Linux Database Benchmarks

Linux Database Benchmarks

The following phrases have been identified by the grok system as matching this entry:

















Also check out:


Grok

Ipod Porn on the
Rise

Brief Abstract of
Wikipedia's
Mesothelioma Cancer
page

Get first aid
instructions in your
cell phone

IE is crap
JSPWiki gains
podcasting support

Goodbye 2004
Top players dial up
3G

Top players dial 3G
Sudan and Southern
Rebels Sign Pact to
End Civil War

Justice Dept.
Toughens Rule on
Torture

Ukraine PM Resigns;
Giant Rally Fetes
Yushchenko (Reuters)

Rising Asian Tsunami
Toll Dims World's
New Year (Reuters)

Yankees to Break
$200 Million
Barrier (AP)

Papers Show Princess
Anne Fought
Abductors (AP)

Lilly Said to Know
of Prozac Risk in
'80s (AP)

Yanukovych Resigns,
Vows to Keep
Fighting (AP)

Powell, Philbin to
Lead NYC Celebration
(AP)

U.S. Memo Broadens
Definition of
Torture (AP)

Exits Locked in
Deadly Argentina
Club Fire (AP)

Aid Arrives in Asia
As Deaths Near
150,000 (AP)

Tsunami survivors
turn to Internet

Darfur Casts Shadow
Over Sudan Peace
Pact in South

No U.S.-UN Rivalry
in Tsunami Aid
Response - Powell

Tracing the missing
The year according
to Ebay

PC sets price for
Kapco IPO at Rs 30
per share

Settlement Recovery
Center Announces
Last Call for
Microsoft Settlement
Money

Bad equipment blamed
in tsunami warnings

Chinese fail to
create standards

Tsunami Resources On
The Internet: At A
Glance

Ukraine PM Resigns;
Giant Rally Fetes
Yushchenko

Swedish PM Under
Fire Over Tsunami
Response

Maxis launches 3G
data card for
notebook computers

Stars unite for
poverty campaign

California sets
fines for spyware

Justice Dept. Memo
Redefines 'Torture'
(washingtonpost.com)

Indonesia Needs
Help, Death Toll
Expected To Exceed
400,000 ::
Bernama.com

Technorati: New
Year's Resolutions
2005

iWork '05
Productivity Suite?

ldap-stats.pl 1.1
Mapview 1.02
StatRelief 0.3.4
meat_hits 0.1.0
Dstat 0.5.7
JBother 0.8.5
Yam 0.7.2
UML2PHP5 1.5
jEdit 4.3pre1
(Development)

lib_rharris 0.1.0
Flash Done Well
The Long Tail
a nice simple
explanation of smart
antenna systems

VeriSign: Online
shopping up 24%
this year

BOR Engine (BORE)
GridAuth
what is grok?