Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XMLUpdateGram() and memo fields
Message
De
13/08/2002 07:42:35
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Divers
Thread ID:
00688966
Message ID:
00689045
Vues:
59
>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

Gee :) A backup log. That's exactly what I did too :) All modifications are converted to XML format, zipped and logged in 1.5 secs for 6K recs modification. I put it in stored procedures and now call SaveData() instead of tableupdate().
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform