> I also have a memo field so I guess your approach
> should speed up the query.
When adding and editing MEMO-Data the FPT-File can become enourmously big.
Issuing a PACK or PACK MEMO on the Table can reduce the file size, in my
case by a few hundred megs!!. That allone can make a vast performance improvement.
> The only issue is that I am calling the query from ASP.NET
> page and I have to figure out how to do 2 select statements instead of one.
> I don't know how or if it is possible to do it.
Eiher make a small COMServer that exposes a method like "GetCustomerBills()" and
returns the necessary records in XML or whatever. Calling the COMServer from ASP.NET
works very well.
Or create a stored Procedure in the DBC. This could be called via the OLEDB-Provider (I guess)
HTH.
Frank