Home » Developer & Programmer » Reports & Discoverer » One query is the best or Two queries regarding Performance ?
One query is the best or Two queries regarding Performance ? [message #89986] Tue, 21 September 2004 05:09 Go to next message
keshav rao chunduri
Messages: 3
Registered: September 2004
Junior Member
Can i know which is the better one among these two given below with specific reasons...

1.  Writing one query is the best thing to retrieve data regarding performance

(or)

2.  Writing two queries is the best thing to retrieve data regarding performance

Can u plz mention me the advantages and disadvantages for using these.

Plz do reply me back which is the best solution.....

 

Report message to a moderator

Re: One query is the best or Two queries regarding Performance ? [message #89992 is a reply to message #89986] Thu, 23 September 2004 03:38 Go to previous message
qqq
Messages: 2
Registered: November 1999
Junior Member
writing a single query is most efficient bcos it will access the database only once.more queries more no of times it has 2 access the DB so less faster the performance

Report message to a moderator

Previous Topic: COUNT_DISTINCT and Percentages Creates Garbage
Next Topic: Select 50 highest data sets
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 09:08:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.