Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Dany Beelen
  Where is Dany Beelen?
 HERK-DE-STAD
 Belgium
 Dany Beelen
 Tags
Subject: RE: SQL SLOW WITH 2 USERS
Thread ID: 228382 Message ID: 228388 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: General VFP Topics
Date: Monday, May 18, 2009 5:53:56 PM         
   


> Hello,
>
> I have a speed problem in my application when 2 users run an sql on a table with +/- 28000 records
> in 2 different forms.
> When 1 users opens his form the process takes about 5 seconds
> When a second users has a different forms open whit he same table and the the first user opens his form again the same process wich took before 5 seconds takes now 55 seconds
> Anybody knows how to solve this problem ??

5 secs to open a form?
With table with only 30000 recs?
What you use to get and set the data?
What is your SQL Select?
Did you begin a transaction w/o closing it?
What SQL Profiler said about that?

-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

SQL SLOW WITH 2 USERS Posted by Dany Beelen @ 5/18/2009 5:31:56 PM
RE: SQL SLOW WITH 2 USERS Posted by Borislav Borissov @ 5/18/2009 5:53:56 PM
RE: SQL SLOW WITH 2 USERS Posted by Dany Beelen @ 5/18/2009 7:35:22 PM
RE: SQL SLOW WITH 2 USERS Posted by Borislav Borissov @ 5/18/2009 8:39:12 PM
RE: SQL SLOW WITH 2 USERS Posted by Dany Beelen @ 5/19/2009 3:43:17 PM
RE: SQL SLOW WITH 2 USERS Posted by Borislav Borissov @ 5/19/2009 3:51:16 PM
RE: SQL SLOW WITH 2 USERS Posted by Dany Beelen @ 5/19/2009 4:06:57 PM
RE: SQL SLOW WITH 2 USERS Posted by Borislav Borissov @ 5/19/2009 5:43:18 PM
RE: SQL SLOW WITH 2 USERS Posted by Dany Beelen @ 5/19/2009 6:09:13 PM
RE: SQL SLOW WITH 2 USERS Posted by Dany Beelen @ 5/19/2009 6:26:11 PM
RE: SQL SLOW WITH 2 USERS Posted by Dany Beelen @ 5/19/2009 6:43:42 PM
RE: SQL SLOW WITH 2 USERS Posted by Borislav Borissov @ 5/19/2009 6:56:45 PM
RE: SQL SLOW WITH 2 USERS Posted by Dany Beelen @ 5/20/2009 12:16:17 PM
RE: SQL SLOW WITH 2 USERS Posted by Dany Beelen @ 6/12/2009 5:11:52 PM