Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: VB MySQL
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
Edited 12-Sep-12 21:16pm
@amitgajjar at 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 at 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=;Min Pool Size=5;Max Pool ize=100;UID=;PWD=;DataBase="
_Amy at 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
0 Sergey Alexandrovich Kryukov 643
1 OriginalGriff 550
2 CPallini 415
3 George Jonsson 231
4 ChauhanAjay 150
0 OriginalGriff 5,450
1 CPallini 4,500
2 Sergey Alexandrovich Kryukov 4,032
3 George Jonsson 3,057
4 Gihan Liyanage 2,445

Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2014
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