Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.paradox    |    To crash or not to crash, asks Borland    |    9,834 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 8,859 of 9,834    |
|    Tony McGuire to All    |
|    Re: Query directly from secondary index    |
|    18 Oct 07 09:53:54    |
      From: png.paradoxcommunity@com              >> But, it will only go through all the rows of the index, not the       >> base table.              > I'm certainly no expert on this but wouldn't the file size of .db       > file have a rather minor impact?              Imagine a 100MB file on network server. With a 500k index file.              A query draws the entire table local, and THEN processes the query.              Which file would you prefer to bring local for the query to act on?              --       ------------------------------        Tony McGuire              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca