• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2182
  • Last Modified:

Embedded MySQL in VB.NET?

Hi. I have a desktop research application that needs very high query performance.

Currently, I am testing Mirosoft Acess vs. Client-Server MySQL and Access is outperforming due to Client-Server limitations.

I'm hoping to try out Embedded MySQL... but I'm using VB.NET.

Any ideas?

I need a basic walkthrough on how to setup my "testing" program to test out Embedded MySQL.

Thanks!
0
oxygen_728
Asked:
oxygen_728
  • 2
  • 2
1 Solution
 
crackyCommented:
I don't want to send you off on a wild goose chase, but if you are looking for an embedded system, then SQLite might serve you better. It's specifically designed for this purpose and it's really easy to set up:

http://www.sqlite.org

See here for a list of .NET related interoperability:

http://weblogs.asp.net/ashben/archive/2003/12/21/44949.aspx

It still surprises me that MySQL is slower than Access. Can you provide a sample query? Are you using indexes?
0
 
oxygen_728Author Commented:
Select Date, Price from Full where Symbol = 'INTC'

yep, using indexes.

I think the issue is the unavoidable overhead in a client-server setup - even on the same computer.

Server-File relationship is much faster apparently.

I'll check those links out as soon as I get time. Thanks!
0
 
oxygen_728Author Commented:
What have I found out about this?

MSDE is probably a better option...

MySQL embedded seems to be C/C++ oriented... though I'm sure there is a way to get it going with VB.NET


So, no real answer, but here's a few pts crack =)
0
 
crackyCommented:
So, no luck with SQLite?

Thanks anyway for the accept :)
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now