Francisco,

>Hi people, actually i am working in a project 2 tier, but i want migrate to 3 tier, but i use a cursor with 200 records and parser every record (i dev a workflow editor and each record is a object where i have a memo where i have all properties), my question is about performance, i obtain an slow parser for using xml parsing or is better use ADO, or is better stay in 2 tier?>

It's a big decision when deciding whether or not to move to true three tier...everything becomes a little more difficult, but you may have compelling reasons to do so. One of these is faster performance that can come from distributed processing. Also, if you have VFP data on the back end, you may not want all workstations attached directly to the data, so that when someone kicks the plug out of their workstation it doesn't corrupt your data.

I prefer to use XML as a transport mechanism between tier 1 and 2. VFP is extremely fast at string manipulation. In version 6.1 of the Framework, I have created a new class called CXML that I use to convert cursors to and from XML. This new class is much faster than using the XML DOM to convert data! In my test case, the XML DOM took approximately 8 seconds to convert my 1,000 record table to XML. The CXML class can do it in subsecond speeds.

Version 6.1 allows you to set up some of your business objects to use three-tier architecture and others to use two-tier.

In VFP7, we get a few new XML commands that can do some of what CXML does for you (I haven't had time to run the official speed comparison yet, but I hope VFP7 is faster!).

Check out the Developer's Guide for information on moving to a three tier architecture.

Regards,