If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > MySQL C Library Speed Problems

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-29-04, 22:42
jjedwards2000 jjedwards2000 is offline
Registered User
 
Join Date: Mar 2004
Posts: 2
MySQL C Library Speed Problems

I made a program in C++ using the MySQL C library that was bundled with my windows build. It turns out that it sends the data at a rate of about 1 kb/s over the internet even on a broadband-to-broadband connection. This connection is low ping about 50 ms and usually can get up to 20 kb/s. Well the program I made sends a significant amount of SQL query text. Sometimes about 2 MB. Is there a way to make this faster. Like is it possible to send 2 queries at once or so (that might help if I can bunch the queries together and send them as 1)? Or is there a way to optimize my configuration for transactions over the internet?

The transactions my client does are only limited to...
- CREATE TABLE
- INSERT

The web site I made does all the SELECTing. But I really don't have any problems with the site, just the client.

I would use the MySQL++ library but it won't compile under Visual Studio .NET.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On