CODEWITHSUNDEEP
mysqlvb6
BellyMark
BellyMark

Reputation: 127

VB6 Fast Performance Database

Sorry for asking a little bit too common question, but I need the advice of an experienced user for solving this problem. Related to some extend with my previous question, I installed MySQL server on my computer running WindowsXP. I managed to connect my VB6 Application with an ODBC driver but the time for instance for adding records was much greater than by adding them to an MSAccess DB. I did this because i needed to get rid of the 1GB file size limitation. Is it normal such a difference and could something be done in order to improve performance?

Upvotes: 1

Views: 743

Answers (1)

Adrian
Adrian

Reputation: 2354

  • Access / JetDB is an in-process database

There is no separate data server with JetDB - the data you insert doesn't have to be marshalled to another process, which will make it faster.

If you want an in-process database that isn't JetDB, try SQLite which does not have the artificial memory limits of JetDB.

  • Try using socket connections

Or "Named Pipes" on Windows - this may be faster than using TCP connections.

Upvotes: 1

Related Questions