<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>The problem is that I am running a ‘simple’ SQL query in the fpSQL window, and before it completes, it aborts with “Index Is Too Big. Rebuild the index using a smaller key.” I am running FilePro on a Windows 7 pc with 16 GB of memory (64 bit operating system). The database that I am querying has 23.7 million records of 369 characters each. The query is: <o:p></o:p></p><p class=MsoNormal> select @5, count(*)<o:p></o:p></p><p class=MsoNormal> from mystuff14<o:p></o:p></p><p class=MsoNormal> group by @5 <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>where Field 5 is a two character state field. Basically, I want to get a list of all the US states in the database and a count per state; I intend to then direct the output to a file.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>But I don’t know how to get around this “index too big” problem. I have been searching on the Internet, and I have been adjusting all the environmental variables that I thought might be relevant ( PFMAXALLOC, PFMAXASIZE, PFMAXTFIL, PFMAXTEMP, PFNUMIXBUF, PFNUMIX BUILD, PFBIXNODESIZE). I have even tried setting all of them to their maximum. No matter what I set, it does not seem to have any impact. For example, I set PFMAXTFIL to numbers greater than 4, (e.g., 8, 16, 32, etc.) and in my tempxxx directory there are always only 4 files of 15,932 KB each. I have made these environmental variable changes using the configuration screen within the FilePro windowed interface, as well as in setenv.bat and fulldev.bat. But, as I said, nothing I do seems to have any impact on this problem.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Any suggestions, comments?<o:p></o:p></p><p class=MsoNormal>Thanks much,<o:p></o:p></p><p class=MsoNormal>Rich<o:p></o:p></p></div></body></html>