🚀 go-pugleaf

Romain Strieff [TeamB] wrote:
> 
> In article <362B3FB9.D55BF58D@notgiven.com>, mike grudgingly admits...
> > I have a 150 Meg page file and the query never fails when i run the
> > query from
> > my local harddisk. however it will fail every time when running it from
> > a network
> > drive. I have supervisor access to the server so it's not a rights issue
> > and I am
> > also the network administrator and have not to my knowledge set up any
> > limits on
> > disk space for users. (not sure you even can, but will check into that)
> >
> > I will go larger on my page file and see it that helps. (I don't think
> > it will
> > but who knows).
> >
> > Any other sugestions?
> >
> Are you using ORDER BY or JOIN which would create a temptable? If yes,
> just use simple SQL and do the ordering with the rowset.indexname and
> joins with the query objects methods instead of the SQL.
> --
> Romain Strieff [TeamB]
> check this URL for all the copies of the
> previous electronic VdB Newsletters
> http://www.openenv.com/feedback/archive/VdBASE/

The problem seems to have gone away.  I am assuming that it has
something
to do with my workstation. 

Thanks for the information on how to set indexes and joins, my next
project
will involve a lot of those activities..

Mike Kirkland