Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLUpdateGram() and memo fields
Message
 
To
13/08/2002 07:22:26
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00688966
Message ID:
00689042
Views:
30
Cetin,

>Yes it'd be. I actually needed it in last week and tried to implement. I didn't have a memo field so I didn't bother with it. During my tests routine got very slow, I narrowed it down to XMLUpdateGram(). For around 6K records it was taking around 71 secs on my system ! I wrote a routine myself and now it runs in 1.5 secs (and I still utilized CursorToXML() modifying a bit).

That's quite a difference in speed < g >. A few days ago I wrote a component where I wanted to have an XML log file. I thought I'll take the easy (and quick and dirty < g >) way and limit the size of the log file to about 1 MB and use CURSORTOXML() and XMLTOCURSOR() to read the whole XML file into a cursor, append my new log entry and write it back as a whole. Really slow <g> - don't remember, but it must have 20 seconds or so. So I went on, did a FILETOSTR(), dropped the closing VFPData tag appended my new entry, appended the tag again and wrote the whole thing back. Now there's no notable time it takes. Press F6 in the debugger and you're right back to a blinking cursor :)

Regards,
Armin

Armin Neudert
Regional Director (Stuttgart) of German FoxPro User Group dFPUG

MCP for Visual FoxPro

Expert/Editor of the VFP section in the German Codezone community portal
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform