General information
Category:
Coding, syntax & commands
How about describing in outline form what you are required to do. This includes each database if more than one, table, and details. I have too many questions at this point to suggest anything.
Tom
>I have the following code that takes forever to run. Can anyone suggest ways of speeding up the process?
>
>select courseid,classid,studentid,birthdate,firstname,middlei,lastname,address,city,state,zip;
>from student;
>where empty(web_exp);
>into table c:\tempweb
>
>open database hunter
>use vwhe_card
>append from c:\tempweb
>
>*!* want to do this later just in case the above didn't work
>select student
>set filter to empty(web_exp)
>replace web_exp with date() all
>
>I've also tried:
>use student
>set filter to empty(web_exp)
>
>open database hunter
>use vwhe_card
>append from student
>
>The database has over 390000 records. For test data, I'm looking for 42 records and it's taking so long. Should I set an index?
>
>I would appreciate any help and thanks in advance!
>Sunshine
Previous
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