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: 8697 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 |
|
|
|