Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Pratik Singh
  Where is Pratik Singh?
 Kota
 India
 Pratik Singh
 Tags
Subject: RE: Optimization Data Retreive
Thread ID: 393707 Message ID: 393716 # Views: 65 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 22, 2013 5:29:15 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

You can always improve performance by restricting the data that is downloaded. What human user can read 10,000 records?
Add a WHERE clause and see what difference that makes
 SELECT * FROM Products WHERE category LIKE '% nail%' 

or whatever serves the user best.

-Anders

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