Re: recordcount without query

[Adam Cameron <adam_junk@xxxxxxxxxxx>]

> without any complicated query.

Well SELECT COUNT(*) FROM table is hardly complicated.

What you could do is add a column to the large table "migrated" or
something like that.  Default the value to 0.

When you query the rows to migrate, do this:

select [column list]
from table
where migrate = 0

After migrating those records, update the original table so that migrate is
1 for those records.

-- 
Adam