Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pratik Singh
  Where is Pratik Singh?
 Kota
 India
 Pratik Singh
 Tags
Subject: Optimization Data Retreive
Thread ID: 393707 Message ID: 393707 # Views: 63 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 22, 2013 12:03:38 PM         
   


Hello Experts,

I have some technical problem with data retrieving with MYSQL hosting database server.
i have just ten thousand record in table and i just simple a query.
but the return cursor records make take a long time and its a irritating reply.
and i tested in my local server but also it takes bit time to reply.

how i optimize this problem
i havnt any index on any field
table have primary key
will this is a problem with index or makeing a data structure
or other issue

i.e: sqlexec(conn,'select * from products','products')




Give solutions

Regards
Pratik


Learning never ends

ENTIRE THREAD

Optimization Data Retreive Posted by Pratik Singh @ 12/22/2013 12:03:38 PM
RE: Optimization Data Retreive Posted by Anders Altberg @ 12/22/2013 5:29:15 PM
RE: Optimization Data Retreive Posted by Binod Binani @ 12/23/2013 10:00:20 AM
RE: Optimization Data Retreive Posted by Pratik Singh @ 12/23/2013 10:42:14 AM
RE: Optimization Data Retreive Posted by Anders Altberg @ 12/23/2013 11:01:28 AM
RE: Optimization Data Retreive Posted by Vivek Deodhar @ 12/24/2013 5:01:16 AM