Mysql Database forms slow

[Derekgirven]

Hi,
I have a Mysql database ,and have built a C# front end in Visual Studio . it works great , just some of my forms pull a bit of info from separate tables using combo boxes .I am using a connection string to retrieve info but it seems to slow and freezes at times .
Is C# and window forms the best way to go or make it using PHP or something similar ?
Any advise ?

 

[Derekgirven]

Hello, this is Gulshan Negi.
Well, for a database-driven application, the choice between C# and Windows Forms or PHP depends on the application's complexity, user interface requirements, and development team skill level. Both C# and PHP have great help for working with information bases, and the decision to innovate will at last depend upon your particular requirements and inclinations. If your C# application freezes or runs slowly when retrieving data from the database, you may be able to improve performance by optimizing your code or queries. Looking for guidance from specialists or different designers can likewise assist you in settling on the most ideal choice for your task.
Thanks

@gulshan212 I am at a loss as I mentioned in the begining I am very much a newby ,so if you could steer me in a dirrection of where to get help that would be great, I felt like I was getting shot down here and got very dispondant . thanks for your reply !

 

[Skydiver]

@Derekgirven : as noted in post #14, there is no need to quote the whole post above yours.

 

[cjard]

What kind of help are you looking for? There are excellent minds here that are great at insight, diagnosis and advice, but I’m afraid that the conversation appears to have gone like:

“I’m a newbie, I need help! It’s slow! Somebody help me?”

“What steps have you taken so far? What does your code do? Where is it slow?”

“I don’t know! I’m a newbie, I don’t know what I don’t know. I don’t know how to find out what I don’t know? It’s not working! Help me! Here’s all my code, you do all the work and tell me what I need to do! I need help!”

“Ok, so you didn’t send any code but here’s a bunch of things that can go wrong, here’s some advice on how to do it right. If you need more specific help you’re going to have to be more specific”

“Ok I’ll try..”

…

“Hey you can try making your queries faster”

“Oh, ok, where can I get help? I need help because I’m a newly! Can someone help me? These guys here didn’t help me, where else should I go?”

—-

Honestly, with this approach you won’t find the help you need anywhere other than paying for it on a freelancer site. On free advice sites you need to be a part of your own rescue; people will pitch in but they won’t do it for you. They will offer advice and improvements on specific parts you’ve been able to isolate that are biting you, but they won’t wade through thousands of lines of code that “doesn’t work” and you “need help with”.

When you converse with software engineers you’re talking to people who think and approach problems in very precise ways. You have to start adopting that methodical approach to digging out the problem. Right now you’ve called the fire service and you’re just babbling down the phone about how your house is burning and you need help.. what you should be doing is telling them where you live, how many lives are in danger, what material is on fire, what the immediate risks are, what the roads getting to you are like, where the hydrant is, what other things are affected..

 

[Derekgirven]

What kind of help are you looking for? There are excellent minds here that are great at insight, diagnosis and advice, but I’m afraid that the conversation appears to have gone like:

“I’m a newbie, I need help! It’s slow! Somebody help me?”

“What steps have you taken so far? What does your code do? Where is it slow?”

“I don’t know! I’m a newbie, I don’t know what I don’t know. I don’t know how to find out what I don’t know? It’s not working! Help me! Here’s all my code, you do all the work and tell me what I need to do! I need help!”

“Ok, so you didn’t send any code but here’s a bunch of things that can go wrong, here’s some advice on how to do it right. If you need more specific help you’re going to have to be more specific”

“Ok I’ll try..”

…

“Hey you can try making your queries faster”

“Oh, ok, where can I get help? I need help because I’m a newly! Can someone help me? These guys here didn’t help me, where else should I go?”

—-

Honestly, with this approach you won’t find the help you need anywhere other than paying for it on a freelancer site. On free advice sites you need to be a part of your own rescue; people will pitch in but they won’t do it for you. They will offer advice and improvements on specific parts you’ve been able to isolate that are biting you, but they won’t wade through thousands of lines of code that “doesn’t work” and you “need help with”.

When you converse with software engineers you’re talking to people who think and approach problems in very precise ways. You have to start adopting that methodical approach to digging out the problem. Right now you’ve called the fire service and you’re just babbling down the phone about how your house is burning and you need help.. what you should be doing is telling them where you live, how many lives are in danger, what material is on fire, what the immediate risks are, what the roads getting to you are like, where the hydrant is, what other things are affected..

Again there is that tone mate !!

 

[JasinCole]

@gulshan212 I am at a loss as I mentioned in the begining I am very much a newby ,so if you could steer me in a dirrection of where to get help that would be great, I felt like I was getting shot down here and got very dispondant . thanks for your reply!

I can appreciate your frustration, for years I felt the same way. It's hard to go from new to making something useful. There is a lot in the transition from basics to advanced concepts and software that you use that has already been written by someone else.

But be mindful you have to put in a lot of effort and nothing in this thread was meant to put you down, in fact it was trying to build you up by giving you guidance on how to get the best help. I do not think anyone here wants to see you fail, so keep that in mind when you get advice.

 

[Derekgirven]

What kind of help are you looking for? There are excellent minds here that are great at insight, diagnosis and advice, but I’m afraid that the conversation appears to have gone like:

“I’m a newbie, I need help! It’s slow! Somebody help me?”

“What steps have you taken so far? What does your code do? Where is it slow?”

“I don’t know! I’m a newbie, I don’t know what I don’t know. I don’t know how to find out what I don’t know? It’s not working! Help me! Here’s all my code, you do all the work and tell me what I need to do! I need help!”

“Ok, so you didn’t send any code but here’s a bunch of things that can go wrong, here’s some advice on how to do it right. If you need more specific help you’re going to have to be more specific”

“Ok I’ll try..”

…

“Hey you can try making your queries faster”

“Oh, ok, where can I get help? I need help because I’m a newly! Can someone help me? These guys here didn’t help me, where else should I go?”

—-

Honestly, with this approach you won’t find the help you need anywhere other than paying for it on a freelancer site. On free advice sites you need to be a part of your own rescue; people will pitch in but they won’t do it for you. They will offer advice and improvements on specific parts you’ve been able to isolate that are biting you, but they won’t wade through thousands of lines of code that “doesn’t work” and you “need help with”.

When you converse with software engineers you’re talking to people who think and approach problems in very precise ways. You have to start adopting that methodical approach to digging out the problem. Right now you’ve called the fire service and you’re just babbling down the phone about how your house is burning and you need help.. what you should be doing is telling them where you live, how many lives are in danger, what material is on fire, what the immediate risks are, what the roads getting to you are like, where the hydrant is, what other things are affected

I can appreciate your frustration, for years I felt the same way. It's hard to go from new to making something useful. There is a lot in the transition from basics to advanced concepts and software that you use that has already been written by someone else.

But be mindful you have to put in a lot of effort and nothing in this thread was meant to put you down, in fact it was trying to build you up by giving you guidance on how to get the best help. I do not think anyone here wants to see you fail, so keep that in mind when you get advice.

Mate thanks , just the tone of a few I felt that they need to prove they are btter then all of us .I agree you are.I am asking for help,we all know some people here are engineers ,and major respect to you . What I am asking is as a "Newby" (the word seems to erratate cjard ) is guidence like try this site it helped me or read up here this may be intersting .I am not trying to shortcut a process I want to learn . I have bought around 10 Undemy courses to try learn . I am asking where could one learn more on a topic that you guys are masters on and not feel intimidated to ask a question.

 

[JasinCole]

@Derekgirven That's exactly what I mean, you aren't taking the advice you are given. That's part of the 'a lot of effort' I was speaking to. You aren't giving meaningful information and presenting it in a way where anyone can help.

If you ask a generalized question you get a generalized answer or none at all. All the replies are imploring you to become a better communicator so you can get help. Take the advice!!

 

[Derekgirven]

@Derekgirven That's exactly what I mean, you aren't taking the advice you are given. That's part of the 'a lot of effort' I was speaking to. You aren't giving meaningful information and presenting it in a way where anyone can help.

If you ask a generalized question you get a generalized answer or none at all. All the replies are imploring you to become a better communicator so you can get help. Take the advice!!

Thanks will take the advise, trust me every repy has been read at least 5 times to try understand what is said .and I apreciate it .

 

[jmcilhinney]

Again there is that tone mate !!

And there's you quoting entire long posts again after having just been asked not to for the second time.

When people start complaining about the tone of replies like that, it's pretty much universally because they've been told that they didn't present their request in the best way to get the help they want. We've all been doing this a while and we know what works best and what doesn't. We'll be here helping other people when you're gone. You just care about getting this problem solved but we care about this site working smoothly for everyone - you, us and others who may find this information later. We don't want to lecture anyone. We just want you to ask a good question so we can provide a good answer and everyone can move on. I suggest worrying less about the perceived tone and more about the content, for you own sake as well as ours.

Of course, I'm also prepared for the main thing you take from this post being the tone as well.

 

[cjard]

I don't get irritated by people being newbies, but I'm less inclined to help when they don't respond to reasonable requests.

I mentor several developers professionally and they have all learned that when I ask a question it's for a reason and when I ask them to do something it's beneficial if they do it.

It isn't always what they want, but often they want me to do their work for them and that is not what mentoring is

 

[Skydiver]

Again there is that tone mate !!

And again there is quoting the entire post...