Click here to Skip to main content
12,948,334 members (66,796 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I'm using VB2008 and and Online MySQL for my database.. Everything is working fine, the problem is each query took time before it displays a result..

Is there anything that i can do to speed it up..

Another thing is, is it possible to connect VB2008 to an online MySQL Database under a Cloud Server?

Any advise would be greatly appreciated!

Posted 12-Sep-12 20:48pm
Updated 12-Sep-12 21:16pm
@amitgajjar 13-Sep-12 3:56am
We can't predict where is the problem. Issue may be from your Stored procedure, query or may be from network traffic. so you have to be very specific for this question. improve question and show us one scenario.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

too Little information to give an answer but I would suggest looking at the following

If the tables are large I would have a look at

a. Paging your data back to the client

Paging In a Datagridview Windows Form[^]

Generic GridView Using DataTable with Sorting and Paging[^]

b. Index the table
Google Search : MySql Indexing Tutorial[^]
chuan0308 22-Sep-12 1:32am
Thanks for the information.. i would study about it and check if it helps..
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

use the below connectivity

"Driver={MySQL ODBC 5.1 Driver};SERVER=<ip address="">;Min Pool Size=5;Max Pool ize=100;UID=<username>;PWD=<password>;DataBase=<databasename>"
_Amy 17-Sep-12 8:02am
Do you think, this is the actual answer the OP is looking for?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,344
CHill60 3,275
Maciej Los 2,703
Jochen Arndt 1,935
ppolymorphe 1,795

Advertise | Privacy | Mobile
Web02 | 2.8.170524.1 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100