Re: recordcount without query

["JFLaplante" <webforumsuser@xxxxxxxxxxxxxx>]

Thanks, I'm going to play with the suggestions.

 The 'reason' I want to do that is because of a legacy DBF file which is 
maintained by an old DOS application.  It contain invoices details and over the 
years, I created a number of subsystems around it.  My client finally agreed to 
migrate the whole ordering/invoicing system to ColdFusion and I need to 
replicate the DBF file on a MySQL server for a few months.

 If I copy the whole million records from the DBF, it takes 8 minutes outside 
of CF and 35 minutes with ColdFusion.  My goal is to copy the bulk of the table 
once and just copy the new records off the top when needed so it will only 
represent a fews msecs instead of a few minutes.  Once the table is in MySQL, 
it can be queried to death without any performance hit.

 By comparing the number of records before and after, I will know how much to 
skim off the top.  There may be another way but I don't see it right now.