Search

Hi all,

I was just wondering what the size limitations of static XML are in a datasource as I've run into an issue.

I need to populate a select field in the frontend with all valid airport codes, and there are a lot of them. I've found a json list here on Github, and converted it to XML and have set up a static Datasource to serve it to the front-end.

However my xpath isn't getting any values, and ?debug is just hanging - I'm wondering if the size could cause an issue, or if quirks in the formatting could cause it to fall over (or would these be caught by validation when creating the datasource?).

A sample of the XML:

<root>
  <entry>
    <continent>OC</continent>
    <iata>UTK</iata>
    <iso>MH</iso>
    <lat>11.233333</lat>
    <lon>169.86667</lon>
    <name>Utirik Airport</name>
    <size>small</size>
    <status>1</status>
    <type>airport</type>
  </entry>

Edit: Not getting data was due to a mistake in the xpath, something I'd have normally picked up looking at the debug :) Cutting out the data I don't need (I only need the code and name) seems to have helped, debug now loads (after a 5 second delay), and the front-end seems OK. Will I see significant performance issues with ~7000 entries coming through like this? Is there a better approach?

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details