Re: refreshRow is slow

Having decided that refreshRow is going to be too slow sometimes (because it does a query for each column to see if it's a primary key), I am for the time being revising my standard application logic to execute the original query again.

A small complication has developed. There is no guarantee that the rows will be returned in the same order, unless the order is explicitly stated in the query. Since my queries are usually user-defined (that is, generated by the application based on user requests in a non-SQL syntax), I'll have to do something like sort on the primary keys in all cases. Not necessarily a bad thing to do I suppose.

But another complication might be confusing to the users. Suppose someone else has added a row. Executing the original query brings up more rows than originally. If the user has been scrolling back and forth through the result set, suddenly a new row will appear. Also possible, someone deletes a row, so it disappears. That is likely to generate a phone call to me ("What happened?").

It sure would be nice if refreshRow was more efficient in learning which are the primary keys.

John