473,387 Members | 1,790 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Which one is best performance?

Hi every body
Well lets assume that we are making a windows application project
and I have a datagird which will contain some data
1) well I can make a command object and give it a query in C# and
execute this command so that the datagrid gets its data.
2) and I can make a Query in the MS Access 2003 for example and I can
execute this query from the C#
Which one of those two methods will have better performance Execute a
query from the C# or call a query from the Access dataBase?
Thank you very much :)
Nov 16 '05 #1
2 1550
I would'nt know if the query object in Access is "pre-compiled" but if
it is then that would be the better performer. You could try preparing
the sql statement in a command object aswell
Hope that helps

Khaled Atta wrote:
Hi every body
Well lets assume that we are making a windows application project
and I have a datagird which will contain some data
1) well I can make a command object and give it a query in C# and
execute this command so that the datagrid gets its data.
2) and I can make a Query in the MS Access 2003 for example and I can
execute this query from the C#
Which one of those two methods will have better performance Execute a
query from the C# or call a query from the Access dataBase?
Thank you very much :)


--
Regards,
Dilip Krishnan
MCAD, MCSD.net
dilipdotnet at apdiya dot com
Nov 16 '05 #2
I think that's extremely wishful thinking
"Dilip Krishnan" <dilipdotnet..NOSPAM..@apdiya.com> wrote in message
news:uG****************@TK2MSFTNGP11.phx.gbl...
I would'nt know if the query object in Access is "pre-compiled" but if
it is then that would be the better performer. You could try preparing
the sql statement in a command object aswell
Hope that helps

Khaled Atta wrote:
Hi every body
Well lets assume that we are making a windows application project
and I have a datagird which will contain some data
1) well I can make a command object and give it a query in C# and
execute this command so that the datagrid gets its data.
2) and I can make a Query in the MS Access 2003 for example and I can
execute this query from the C#
Which one of those two methods will have better performance Execute a
query from the C# or call a query from the Access dataBase?
Thank you very much :)


--
Regards,
Dilip Krishnan
MCAD, MCSD.net
dilipdotnet at apdiya dot com

Nov 16 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: loquak | last post by:
Greets. I wonder which way would be the best for holding some state flags in terms of memory use and efficiency. a) struct FLAGS { bool flag1 : 1; bool flag2 : 1;
7
by: SQLDBA | last post by:
I am in the process of evaluating some SQL Performance Monitoring /DBA tool to purchase (For SQL Server 2000). I have the following list of software that I came across and have to finalize which...
14
by: Bob | last post by:
I have a function that takes in a list of IDs (hundreds) as input parameter and needs to pass the data to another step as a comma delimited string. The source can easily create this list of IDs in...
3
by: Balaji Kannan | last post by:
Hi, In dot net during component development i have used some member variables in the class file. Inside the class i have used the member declaration and the instant handling in the following...
4
by: Lerp | last post by:
Hi all, With regards to calling data from a database and filling in an editing form based on some query, which is the best (least intensive on processor) method for assigning the returned...
9
by: Luke Vogel | last post by:
Hi all. This is a bit of a newbie type question. I am trying to figure out what is the best way to connect to a database; ado.net, odic others? I've found a couple of examples that show you...
7
by: toton | last post by:
Hi, I want a circular buffer or queue like container (queue with array implementation). Moreover I want random access over the elements. And addition at tail and remove from head need to be low...
2
by: tulasikumar | last post by:
hi all, i have one doubt regarding queries and stored procedures.i am doing asp.net project,i had written both query based retriving and stored procudures.I want know about which one was giving...
3
by: samadams_2006 | last post by:
Hello, I'm interested in taking the following exam for an upcoming job. Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C#â„¢ .NET and Microsoft Visual Studio...
20
by: mike3 | last post by:
Hi. (Xposted to both comp.lang.c++ and comp.programming since I've got questions related to both C++ language and general programming) I've got the following C++ code. The first routine runs in...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.