Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
Ahhhh, is that all he wants? I use "WHERE .F." to get an empty cursor/table.
>Mathias;
>
>If all you need is a blank table then I like to use SELECT * FROM MyTable WHERE 1>2. This avoids picking up a blank record. :)
>
>I would suggest trying this on your local machine. You have to know how much degradation is due to your network. Firewalls and antivirus programs can slow things down, on local machines as well as servers.
>
>What network are you using?
>
>Tom
>
>
>>Well,
>>
>>The initial query is:
>>
>>Select a.field1 As Code, a.Field2 As Desc From TableA a Into Cursor tmpCursor
>>
>>The table has an index on field1 so I added:
>>
>>where a.Field1 = ""
>>
>>It's a cheat I know but the query is optimised and works as long as set exact off.
>>
>>The time jumps from 5 secs to under 2.
>>
>>Regards
>>>>Hi Mike,
>>>>
>>>>Yes I can and I have by introducing a dummy where clause. It optimises and halves the time roughly 2 seconds.
>>>>
>>>
>>>Hi Mathias,
>>>
>>>Can you expand a little on this "dummy where clause" idea?
>>>
>>>Regards,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only