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


> > thisform.cmbArart.Rowsource = thisformset.sqlCmbArart
> > Rushmore optimalization level for table arti: none
> >
> > In thisformset.sqlCmbArart the sql phrase is stored
>
> Can you post the exact INDEX expression of that table?
> Something is wrong with the WHERE clause. It doesn't match the INDEX expression and that is why you can't use Rushmore.
>
>
> -----------------
> 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.

I have made a small example of the instruction
When I run it single on the pc with the table it runs in 1 second
When I run it single on a other pc over the network it runs in 3 seconds
When I first run it on the pc with the table and leave the browse open and then on the other pc over the network ik takes 9 seconds
Here is my example

PARAMETERS p1
WAIT "STOP 1 " + TIME() WINDOW AT 35,55 nowait
USE m:\allround\shop22\arti order tag arart again IN &p1 shared
SELECT arti
SELECT arart, argenr, ardesc, arverk1 FROM arti WHERE !DELETED() .and. arart <> 0 INTO CURSOR sqlArtiupd1Arti'+p1+' NOCONSOLE ORDER BY arart '
SELECT sqlartiupd1arti
WAIT "STOP 1 " + TIME() WINDOW AT 38,55 nowait
browse
SELECT arti
use

on the 1 pc i run do prg\test with "1001"
on the 2 pc " " " " "1002"

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