1 / 22

Oracle vs. SQL Server

Oracle vs. SQL Server. SysTalk, the only Dedicated, ISO 9000 Certified BizTalk Company in Australia. www.systalk.com.au. robl@systalk.com.au. The Lizard = Data. National Human Genome Research Institute ENCODE Project: ENCyclopedia Of DNA Elements Anolis carolinensis (Green anole lizard)

marv
Download Presentation

Oracle vs. SQL Server

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle vs. SQL Server

  2. SysTalk, the only Dedicated, ISO 9000 Certified BizTalk Company in Australia www.systalk.com.au robl@systalk.com.au

  3. The Lizard = Data • National Human Genome Research Institute • ENCODE Project: ENCyclopedia Of DNA Elements • Anolis carolinensis (Green anole lizard) • 35,642,840 (50 byte) contigs • 7,233 Scaffolds • 8,354,004 Repeating Sequences • (1,782,142,000 Individual DNA elements)

  4. Data

  5. Setup Oracle Database 11g SQL Server 2005

  6. Test #1 -Performance • Inserts • Updates • Deletes • Selects

  7. TEST_INSERT • LOOP 100,000 • INSERT Record • COMMIT • END LOOP

  8. TEST_UPDATE • UPDATE • COMMIT

  9. TEST_INSERT_WITH_TRANSACTION • BEGIN TRAN • LOOP 1,000,000 • INSERT Record • END LOOP • COMMIT

  10. TEST_DELETE • DELETE FROM TABLE • COMMIT

  11. TEST_SELECT_COUNT_START_REPEATS • SELECT COUNT(*) FROM REPEATS

  12. TEST_SELECT_COUNT_START_DNA • SELECT COUNT(*) FROM DNA

  13. TEST_SELECT_JOIN_AND_SUM SELECT SUM(R.SCAFFOLD_END) INTO CCOUNT FROM REPEATS R, SCAFFOLDS S WHERE R.SCAFFOLD_NAME = S.SCAFFOLD_NAME AND S.SCAFFOLD_NAME like 'scaffold_1%';

  14. Test #2 -Locking • Row Multiversioning • NOLOCK or READUNCOMMITTED • READPAST • Writers vs Readers • SNAPSHOT_ISOLATION

  15. TEST_SELECT_ACROSS_LOCK BEGIN TRAN UPDATE REPEATS SET SCAFFOLD_END = 0 WHERE ID = 80221

  16. TEST_SELECT_ACROSS_LOCK • ALTER DATABASE SvO • SET ALLOW_SNAPSHOT_ISOLATION ON • ALTER DATABASE SvO • SET READ_COMMITTED_SNAPSHOT ON

More Related