Re: Handling more than 2 GB in a table.

From: Gerben Kessen (gerben.kessen(_at_)wantit.nl)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 13:47:25 +0200

<CINDY>
Hi Nadee,

You can find a way to split the table horizontally such as A-M and N-Z. You
can also split the table vertically so each file has the primary key and
some columns are in one table and the rest are in the other table.

You'll be interested in reading "The Ultimate Power & Speed of VFP
Handling Extremely Large Data Sets" ,
http://advisor.com/Articles.nsf/aid/MATIV02 . 

-- 
Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org  www.cindywinegarden.com
</CINDY>
_______________________________________________
<FRED>
You might be able to horizontally split the tables:
Split the SQL table into multiple VFP tables.  Select just some of the
fields into the first table (including the ID field), select other fields
and the ID field, etc.
If that doesn't work, then pull all fields, but only for a smaller subset of
records, into as many tables as needed.
Fred
Microsoft Visual FoxPro MVP
</FRED>
"Gon Nadiya" <WazHot@mymail.com> wrote in message
news:%23QRO%238hlEHA.1652@TK2MSFTNGP09.phx.gbl...
> Hi all,
>
> I want to download a table from the SQL Server to VFP 8 using SQLEXEC().
> when I download some tabels I'm getting the error
> "File C:\Document and setting\Admin~1\Locals~1\temp\f0W4002v.tmp is too
> large. "
>
> This is because the file I'm downloading is greater then 2 GB in size.
> As I got to know VFP can handle tables only upto 2 GB.
>
> Is there a way I can overcome this.
>
> Nadee.
>
>
>
>

Relevant Pages

  • Re: COM-Server
    ... Dazu musst du Threaden/Forken und das kann VFP von Haus aus nicht. ... Download durchführt (Angaben zum Download findet der COM-Server in ... Ich habe dazu mal ein wenig mit dem Threading von .NET experimentiert und ...
    (microsoft.public.de.fox)
  • Re: "Off the shelf" VFP sales entry system
    ... There are some frameworks for VFP on Universalthread. ... but you can download them and see. ... >willing to listen - neil at frittering dot co dot uk ...
    (microsoft.public.fox.programmer.exchange)
  • Re: run a remote command
    ... I would like to have a VFP program work as a control centre. ... "Cindy Winegarden" wrote: ...
    (microsoft.public.fox.helpwanted)
  • Re: IE stops when going into some sites including Yahoo mail
    ... "Cindy" wrote in message ... SP2 is much more sensitive to malware. ... Alternative download pages for Ad-Aware, Spybot, HijackThis and CWShredder ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Visual FoxPro 9.0 Beta available
    ... "Eric den Doop" a écrit dans le message de ... > The Visual FoxPro 9.0 public beta is now available for download! ... > important VFP related news. ...
    (microsoft.public.fox.helpwanted)