PureBasic Forums - English

Binding variables in sql statement is preferred way avoiding common sql injection.

literal strings feature is convenient too.

I'm not sure if it will speed up when I use string functions. Expat is already fast in reading xml but processing in single thread on a large xml seems to take time.
Microsoft Excel can import XML file but for a 500gb XML it takes a long time to import and it makes excel unresponsive. I'm thinking ...

Does anybody has suggestion on how to read XML faster on large XML files? XML file size ranges from 50-500mb.
It takes so long to read large xml files sometimes hours for large xml.


My data in xml file are predictable with similar data below.
<element>
<more>more elements</more>
</element ...

By the way I used directly the code and not the compiled dll.
I'm trying to update the wall data on real-time and check if route is possible but encounter same error.
It works if I don't update the wall data.

Here's how i did.

CreateArea(512) ; init area

;update/change all wall data in real-time ...

Thanks JPS is really fast
Is it stable to be used for our games? Can you give a quick hint on how to avoid it from clinging/hugging wall to make it more natural?