|
View previous topic :: View next topic
|
| Author |
Message |
kacks7
New User
Joined: 22 Sep 2010
Posts: 33
Location: chennai(india)
|
|
|
|
hi all,
I want to fetch some large data from from database , for this which will be better on performance basis
1)easytrieve db2
2)cobol db2 |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| db2 UNLOAD |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Don't know, but, subject to Dick's response not fitting your requirements for some reason, set up a test with each. Run them. Have a look at the stats. |
|
| Back to top |
|
|
kacks7
New User
Joined: 22 Sep 2010
Posts: 33
Location: chennai(india)
|
|
|
|
| Bill Woodger wrote: |
| Don't know, but, subject to Dick's response not fitting your requirements for some reason, set up a test with each. Run them. Have a look at the stats. |
thanks for your response , i made a sample run(with sample data) both are running almost same. |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| kacks7 wrote: |
| Bill Woodger wrote: |
| Don't know, but, subject to Dick's response not fitting your requirements for some reason, set up a test with each. Run them. Have a look at the stats. |
thanks for your response , i made a sample run(with sample data) both are running almost same. |
And why didnt you that before ? Some people lost valuable time of their lives trying to understand your question. |
|
| Back to top |
|
|
kacks7
New User
Joined: 22 Sep 2010
Posts: 33
Location: chennai(india)
|
|
|
|
| PeterHolland wrote: |
| kacks7 wrote: |
| Bill Woodger wrote: |
| Don't know, but, subject to Dick's response not fitting your requirements for some reason, set up a test with each. Run them. Have a look at the stats. |
thanks for your response , i made a sample run(with sample data) both are running almost same. |
And why didn't you that before ? Some people lost valuable time of their lives trying to understand your question. |
actually my requirement is to use large database, while using small (sample datas) i am not able to justify the performace of both thats why asked suggestion. is it wrong, if so i am sorry for that.  |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| kacks7, you DO realize that the database access and query logic will have VASTLY more of an impact on the performance of your query than the choice of language -- to the point of making language choice almost totally irrelevant? |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
| For DB2 it doesn't really matter which language is calling. |
|
| Back to top |
|
|
|
|
