Isn't Pervasive fun. Are you running your odbc connections to Pervasive using the client engine or the Engine interface? Pervasive also works in interesting ways... it can actually download the records to the local machine and use the local machine to process them....... You will find that there is a pretty substantial temporary file created locally and a fair amount of data being brought down over the network....

You may have to break the task into bits to have it process.

The option of extracting the Pervasive information to an intermediate one is also worth thinking about.

Pervasive also has issues with indexes..... you may need to look at the sql you are using...

Michael