Re: SQL or MySQL with c# - C# Discussion Boards

3-Jan-09 1:03

Dear All,
I have developed many database applications with vb6,vb.net,c# as front end and SQL SERVER and MySQL as Back End.
In truth i checked different tables and views in both SQL SERVER and MYSQL. I got better performance (fast) in SQL SERVER (my own check in a view which had 10000 records). I search alot and find out different ideas about them.
I found in some website that MySQL is faster than SQL SERVER while in other i found that SQL SERVER is faster in performance than MySQL.
In fact i dont know, now the question is what to use with c#, MySQL or SQL SERVER?
if MYSQL than which Engine?

Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer

Henry Minute3-Jan-09 1:49

Henry Minute

3-Jan-09 1:49

There is no 'correct' answer to your question.
If you are coding for fun/your own use, use whichever you prefer, for whatever reason you prefer it. It doesn't matter.
If you are coding in the commercial world it is unlikely that you will get a choice. On those rare occasions that the customer has no preference you should provide them with an honest comparison of the pros and cons of each system. In my experience that means they will elect to use MS SQL Server because of the perceived (often wrongly) support issues from a non open source product.

Honi soit qui mal y pongs - Evil to he who thinks it stinks

Abdul Rahman Hamidy3-Jan-09 2:35

3-Jan-09 2:35

Here in Afghanistan, If you prefer MS SQL Server, then of course the price for that application will increase and if u get MySQL then u have to consider about the performance,replication,recovery and security.
My question is regarding only performance, that which one of these two RDBMS provides faster performance.

Thanks,

Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer

Aman Bhullar3-Jan-09 5:21

Aman Bhullar

3-Jan-09 5:21

IF you are using .net as a fron end, then best RDBMS option available is MS SQL. There is a performance gain when we use MS SQL as back end.
And the performance gain is not negligible.

Regarding cost factor for original. Do not install it on your computer. Have one with web hosting account.
Install SSMSE(Its free) on you PC. Connect to remote server and do your job.

N a v a n e e t h3-Jan-09 16:14

N a v a n e e t h

3-Jan-09 16:14

It's very tough to say which is better. I have a high traffic website which uses MySQL as backend and works like a charm. It gives good performance. But you can gain that only by optimizing your queries and code. Proper indexing also reduces the query execution time.

BTW, how are you connecting to MySQL from C#? Is it through Oledb? If yes, that might be the reason for bad performance. Oledb is slow and you should consider the MySQL connector provided by MySQL which can be downloaded from MySQL site. I'd suggest to go with MySQL (5.0 or later).

Navaneeth

How to use google | Ask smart questions

Abdul Rahman Hamidy4-Jan-09 0:30

4-Jan-09 0:30

I am using MySql.Data.dll with c#, there is no OleDb.
In here if some one asks me what u recommend as back end with c#, i really get stacked, because now i have read different articles about both of them, in truth i do really appreciate to have trusted reference regarding benefits of each and disadvantage of each.

Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer

Wendelius4-Jan-09 1:20

Wendelius

4-Jan-09 1:20

I think it's impposible to say which one is better. The choice depends on many factors like:
- investment costs (both hardware and licenses)
- desired support level and are you willing to pay for it
- possibly existing databases (why bring a new product if existing are implemented using a different product)
- how familiar you/your team is with the product
- what is the future roadmap for the product etc.

From my experiences, if you are worried about the performance, there's very little difference between different databases, but the way how you get most out of them may be different. So the optimization process may not be equal. However, most of performance isn't coming from the database itself, instead it's how you use it:
- database modelling
- indexing
- types of sql statements
- application logic
- number of roundtrips etc.

If I should say something good for both products:
- both SQL Server Express Edition and MySQL are free to use
- SQL Server has more capabilities and features than MySQL
- MySQL group is very active but the information may be scattered
- integration for SQL Server in .Net is better

But as said, you should think of your environment and your needs in order to make the decision. One product isn't the best choice in all cases, so there's no absolute truth.

The need to optimize rises from a bad design.My articles[^]

Abdul Rahman Hamidy4-Jan-09 22:57

4-Jan-09 22:57

thx alot, infact u solved my problem.
i am sure, after this i would use RDBMS based on Envoirnment and for solving cost i would use SQL Express Edition which is free instead of Management studio.
your answer is really appreciated,
thanks,

Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer

Wendelius5-Jan-09 6:06

Wendelius

5-Jan-09 6:06

Abdul Rahman Hamidy wrote:
thx alot, infact u solved my problem

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

About PostMessage() API

tr_thorn3-Jan-09 1:01

tr_thorn

3-Jan-09 1:01

Hi i wanna do a bot program for a game.This program send key strokes to Game Application.But i got a problem.I only wanna send key to Game Application Window Handle not another active window.I write a class for this but i havent get worked it.Its sending keys only notepad not to game or any other window.Can ya help me for this ? Iam sending ya codes below ; and tell me where is my problem. thanx for ur help.

class SendKeySample
{
private static Int32 WM_KEYDOWN = 0x100;
private static Int32 WM_KEYUP = 0x101;

[return: MarshalAs(UnmanagedType.Bool)]
[DllImport("user32.dll", SetLastError = true)]
static extern bool PostMessage(IntPtr hWnd, int Msg, System.Windows.Forms.Keys wParam, int lParam);

[DllImport("user32.dll", SetLastError = true)]
private static extern IntPtr FindWindowEx(IntPtr hwndParent, IntPtr hwndChildAfter, string lpszClass, string lpszWindow);

public static IntPtr FindWindow(string windowName)
{
foreach (System.Diagnostics.Process p in System.Diagnostics.Process.GetProcesses())
{
if (p.MainWindowHandle != IntPtr.Zero && p.MainWindowTitle.ToLower() == windowName.ToLower())
return p.MainWindowHandle;
}

return IntPtr.Zero;
}

public static IntPtr FindWindow(IntPtr parent, string childClassName)
{
return FindWindowEx(parent, IntPtr.Zero, childClassName, string.Empty);
}

public static void SendKey(IntPtr hWnd, System.Windows.Forms.Keys key)
{
PostMessage(hWnd, WM_KEYDOWN, key, 0);

}
}

Calling Code ;

var hWnd = SendKeySample.FindWindow("Untitled - Notepad");
var editBox = SendKeySample.FindWindow(hWnd, "edit");

SendKeySample.SendKey(editBox, Keys.A);

Windows Users

yogesh_kumar_agarwal3-Jan-09 0:32

yogesh_kumar_agarwal

3-Jan-09 0:32

Dear All

I want to create a form in C# by that a user is unable to change the users detail for windows.

Means i want to change, create users in windows using c# application.

How could i do the same. plz reply

Regards

Yogesh

pikmindoctor3-Jan-09 4:25

pikmindoctor

3-Jan-09 4:25

Try rephrasing your question - It's difficult to read.

EliottA3-Jan-09 10:50

EliottA

3-Jan-09 10:50

I think he wants to control user accounts and their permissions...

yogesh_kumar_agarwal5-Jan-09 23:33

yogesh_kumar_agarwal

5-Jan-09 23:33

Yes, you are right i want to do the same.