I'm just wondering, when a query executes the SQL Statements does it send the query to the SERVER for processing or does it merely fetches each and every row and the calculation is performed in the client machine on each and every record fetched???
Or how is it done??
The reason i ask is because my pc becomes really slow and sometimes hang when I process query with "Computed Items" or more complex SQL WHERE CLause statements.
Anyone has any idea what I can do to prevent this 'hang-time' for my PC?