Click here to Skip to main content
15,915,082 members
Home / Discussions / Database
   

Database

 
QuestionConnectionString Changes during Runtime? Pin
DEWright_CA24-May-06 5:38
DEWright_CA24-May-06 5:38 
Questionreturning a user group in MS Access Pin
achrafus24-May-06 4:07
achrafus24-May-06 4:07 
QuestionInserting lots of rows programmatically Pin
AnneThorne24-May-06 2:59
AnneThorne24-May-06 2:59 
AnswerRe: Inserting lots of rows programmatically Pin
john.nada24-May-06 5:33
john.nada24-May-06 5:33 
GeneralRe: Inserting lots of rows programmatically Pin
AnneThorne24-May-06 8:59
AnneThorne24-May-06 8:59 
GeneralRe: Inserting lots of rows programmatically Pin
Eric Dahlvang24-May-06 11:59
Eric Dahlvang24-May-06 11:59 
GeneralRe: Inserting lots of rows programmatically Pin
john.nada24-May-06 12:07
john.nada24-May-06 12:07 
QuestionODP.NET vs System.Data.OracleClient Pin
CooperWu24-May-06 0:11
CooperWu24-May-06 0:11 
hi all,
which one faster? ODP.NET or System.Data.OracleClient.

I do a test on my computer. the result following:
--
System.Data.OracleClient
100
00:00:03.0156250
10'000
00:00:03.0156250
100'000
00:00:04.2187500
1'000'000
00:00:13.5000000

Oracle.DataAccess.Client
100
00:00:03.1875000
10'000
00:00:13.3750000
100'000
00:01:53.0000000
1'000'000
(I don't test this item Frown | :( I think it will be take a long time, so I don't test it.)

--
my computer environment
os: windows 2003 server enterprise edition - sp1
computer:
Intel(R) Celeron(R) CPU
2.53 GHz
2.55 GHz, 736MB of RAM.
--

How do you think about this? I thought the ODP.NET would be faster that System.Data.OracleClient before test.
AnswerRe: ODP.NET vs System.Data.OracleClient Pin
CooperWu24-May-06 0:36
CooperWu24-May-06 0:36 
AnswerRe: Query With Collection Values Pin
CooperWu24-May-06 0:19
CooperWu24-May-06 0:19 
QuestionParameterized query Pin
dayakar_dn23-May-06 23:50
dayakar_dn23-May-06 23:50 
AnswerRe: Parameterized query Pin
CooperWu24-May-06 0:24
CooperWu24-May-06 0:24 
AnswerRe: Parameterized query [modified] Pin
Luis Alonso Ramos24-May-06 19:49
Luis Alonso Ramos24-May-06 19:49 
Questioncreate forenkey syntex Pin
vipinpaliwal198023-May-06 22:19
vipinpaliwal198023-May-06 22:19 
AnswerRe: create forenkey syntex Pin
maryamf24-May-06 12:03
maryamf24-May-06 12:03 
AnswerRe: create forenkey syntex Pin
Colin Angus Mackay25-May-06 9:41
Colin Angus Mackay25-May-06 9:41 
GeneralRe: create forenkey syntex Pin
vipinpaliwal198025-May-06 17:54
vipinpaliwal198025-May-06 17:54 
QuestionDbf Tables & Sql Strings Pin
Vinicius Pontes23-May-06 10:11
Vinicius Pontes23-May-06 10:11 
AnswerRe: Dbf Tables & Sql Strings Pin
Eric Dahlvang24-May-06 3:06
Eric Dahlvang24-May-06 3:06 
Question-- Is it possible??? -- Pin
WetRivrRat23-May-06 9:56
WetRivrRat23-May-06 9:56 
AnswerRe: -- Is it possible??? -- Pin
Eric Dahlvang24-May-06 3:36
Eric Dahlvang24-May-06 3:36 
GeneralRe: -- Is it possible??? -- Pin
WetRivrRat24-May-06 4:01
WetRivrRat24-May-06 4:01 
AnswerRe: -- Is it possible??? -- Pin
Eric Dahlvang24-May-06 8:35
Eric Dahlvang24-May-06 8:35 
AnswerRe: -- Is it possible??? -- [modified] Pin
Michael Potter24-May-06 3:41
Michael Potter24-May-06 3:41 
GeneralRe: -- Is it possible??? -- Pin
WetRivrRat24-May-06 4:16
WetRivrRat24-May-06 4:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.