home bbs files messages ]

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