Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Json tool for Working with VFP9SP2
Message
From
07/11/2023 06:27:22
 
 
To
06/11/2023 02:41:05
General information
Forum:
Visual FoxPro
Category:
Web Services
Miscellaneous
Thread ID:
01687181
Message ID:
01687214
Views:
50
Likes (1)
If it is not near-real.time-critical, all should work.
Measure with 10, 100, 1000, 10000 times of reccount()
to see any exponential dangers.

OTOH Record size probabky 1st to degrade total perf...

Calling into Dotnet MIGHT be safer for future JSON enhancements
but offer less ease debugging.

HTH
thomas

>Thank you, for your time.
>
>I won't process a lot of records, just some records. On the other hand, I need to process those records (receive the jsons recods conmvert it to cursors, do some processes on each record and this processes would give me a result in a cursor and convert this cursor back into json so the web service can return them properly. I should mention that the requirement to use Json comes from a partner to the company which I work for, we need to share some data. So, return "standard" Json should important too. Is nfJson capable of those two important aspects?
>
>TIA
>
>
>>Hank already pointed you to a solution probably good enough.
>>
>>>By "best" I mean the easiest, fastest and most standardized tool to interact with VFP 9.
>>
>>I doubt you will tax vfp with nfJSON while you still have lots of control.
>>But as you specifically ask to create a cursor and "fastest", I'd look at creating a byte stream
>>from JSON, which is string handling.
>>Marshalling once into Dotnet or even calling another process to parse hundreds of MByte
>>to either create csv, SDF or a dbf as byte stream will have a fixed call overhead and process
>>each JSON record faster, so for large reccount() and large recsize() with many I, D,Y fields
>>calling into Dotnet or a C process will be faster - you could also write out the dbf file as stteam.
>>
>>HTH
>>thomas
>>
>>
>>>Hi. I'll begin to develop a small web service in VFP 9. This web service will receive and send Json data. But I need to know what is the best available tool for encoding/decoding Json strings. By "best" I mean the easiest, fastest and most standardized tool to interact with VFP 9. Of course, if it would allow me to create cursor from Json, that would be a big plus.
Previous
Reply
Map
View

Click here to load this message in the networking platform