|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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).
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Abdul Rahman Hamidy wrote: thx alot, infact u solved my problem
You're welcome 
|
|
|
|
|
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);
|
|
|
|
|
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
|
|
|
|
|
Try rephrasing your question - It's difficult to read.
|
|
|
|
|
I think he wants to control user accounts and their permissions...
|
|
|
|
|
Yes, you are right i want to do the same.
|
|
|
|
|
That's too vague. Do you want to crud the local accounts, or do you want to administer all the network-accounts as well?
IOW; do you want to make new users on YOUR pc, or do you want to make new users on the network?
I are troll 
|
|
|
|
|
i want add control when program run then apply event for it? please help
|
|
|
|
|
Like this:
TextBox box= new TextBox();
box.TextChanged += new (TextChangedHandler);
this.Controls.Add(box);
|
|
|
|
|
I have to convert pdf to doc in .net
I have tried some dll's but they are not preserving the image
and the formatting of the text.
Any solution or idea except code project's article on pdfbox.
Don't walk as if u rule the world,walk as if u don't care who tha Hell rules the world ...
|
|
|
|
|
Google around for more libraries that support doing this. I don't know of any since I have never used PDF in my apps.
|
|
|
|
|
Dear Friends,
i am working on a project where we need to install application in remote machine,
now i want to install .Net Framework to Install.
i want to know how to install .Net Framework without wizard??
please help Me?
Any idea?? Any References??
BY
Joe.I
|
|
|
|
|
Is there a specific reason for installation without wizard? AFAIK, you can't control it.
|
|
|
|
|
Try launching the dotnetfx.exe with the /Q command line switch:
dotnetfx /q
|
|
|
|
|
Dave Kreskowiak wrote: dotnetfx /q
WOW! New information to me. Thanks
|
|
|
|
|
Make the wizard leave the room before you install it.
(I love the easy questions like this one.)
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Dear Sirs:
I have a C# application with a ToolStrip control and a RichTextBox control.
Three of the buttons on the toolStrip are for formatting the text in the RichTextBox, i.e., Bold, Italic, and Underlined. I have the CheckOnClick property set to true for these 3-buttons. My code successfully sets the selected text to any\all of the above formatting.
However, the button's CheckState remains "Pressed" or clicked, unless I physically unclick it. What I want to do is emulate what occurs in a WordPad document, where by both scrolling over formatted text, or clicking into formatted text causes the Bold button, Italic button, or Underline button(s) to appear depressed or clicked and conversely, to not appear depressed or clicked when the user clicks outside of the formatted text or scrolls past it.
Does anyone know how to accomplish this in C# and also what event(s) to place this code in, so that this happens smoothly for the end-user?
Thank you in advance for your answer
Richard
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
