Click here to Skip to main content
Rate this: bad
good
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!
 

 
Thanks!
Posted 12-Sep-12 20:48pm
Edited 12-Sep-12 21:16pm
v2
Comments
@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
good
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[^]
  Permalink  
Comments
chuan0308 at 22-Sep-12 1:32am
   
Thanks for the information.. i would study about it and check if it helps..
Rate this: bad
good
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="
  Permalink  
Comments
_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 Richard MacCutchan 335
1 OriginalGriff 310
2 Sergey Alexandrovich Kryukov 239
3 Sharmanuj 146
4 Magic Wonder 129
0 Sergey Alexandrovich Kryukov 5,999
1 OriginalGriff 5,115
2 CPallini 2,473
3 Richard MacCutchan 1,597
4 Abhinav S 1,505


Advertise | Privacy | Mobile
Web04 | 2.8.140814.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