Re: recordcount without query

["JFLaplante" <webforumsuser@xxxxxxxxxxxxxx>]

I tried adding a column but the DOS application freaks out when I do that...

 Still, even when using this method, the query is resource intensive because 
the DBF format is pretty inefficient.   I'm experimenting with various JDBC DBF 
drivers presently.  There's a definitive performance gain compared to the 
Microsoft VFP but they are also pretty expensive.

 You are right when you say that SELECT COUNT(*) FROM table is not a 
complicated query.  What I meant was that this basic information should be 
available very fast the size of a file in a directory.

 I been programing with ColdFusion since version 1.0 when it was bundled FREE 
with Oreilly Website PRO software back in 1995 and this is one of the 
situations that looked simple but isn't that easy to implement at minimal cost 
resource and  money wise.

 The very best way would be some kind of synchronization from within MySQL via 
a stored procedure but I haven't found how to do that either.  In that case, CF 
is just an unnecessary middleman.