Re: [Config] Extremely slow

Here's my XML-file...it's kind of a datastructure for a Database. I'm gonna provide you with some Benchmarks ASAP - strange(?) thing: Runs perfect on my windows-machine, runs slow on the Linux Webserver ... don't know the hardware-config but it's definitely faster than my home-office Celeron@1700 256MB. What about the memory_limit in the php.ini? It's set to 8M on the Linux-Server. Tried to push it up via ini_set() but it didn't make a difference... <!-- SNIP --!> <?xml version="1.0" encoding="ISO-8859-1"?> <datastructure> <database db_name="main[test]"> <table tbl_name="tdta_user"> <field f_name="ixUser" primary="1"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>UserID</alias> </field> <field f_name="fixAddress"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>UserAddressID</alias> </field> <field f_name="fixEmail"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>UserEmailID</alias> </field> <field f_name="fixMembercard"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>UserMemberCardID</alias> </field> <field f_name="cFirstname"> <type>string</type> <length>30</length> <minlength>2</minlength> <alias>Vorname</alias> </field> <field f_name="cUsername"> <type>string</type> <length>30</length> <minlength>2</minlength> <alias>Username</alias> </field> <field f_name="md5Password"> <type>string</type> <length>32</length> <minlength>32</minlength> <alias>md5Passwort</alias> </field> <field f_name="cPassword"> <type>string</type> <length>15</length> <minlength>6</minlength> <alias>Passwort</alias> </field> <field f_name="cLastname"> <type>string</type> <length>30</length> <minlength>2</minlength> <alias>Nachname</alias> </field> <field f_name="eGender"> <type>enum</type> <length> <value_1>f</value_1> <value_2>m</value_2> </length> <alias>Geschlecht</alias> </field> <field f_name="txtComment"> <type>string</type> <length>65535</length> <minlength>0</minlength> <alias>Kommentar</alias> </field> <field f_name="cReferrer"> <type>string</type> <length>30</length> <minlength>0</minlength> <alias>Referrer</alias> </field> <field f_name="iBirthday"> <type>int</type> <length>10</length> <minlength>7</minlength> <alias>Geburtstag</alias> </field> <field f_name="iLastlogin"> <type>int</type> <length>10</length> <minlength>10</minlength> <alias>Letzter Login</alias> </field> <field f_name="iLogincount"> <type>int</type> <length>6</length> <minlength>0</minlength> <alias>Anzahl Logins</alias> </field> <field f_name="bDeleted"> <type>enum</type> <length> <value_1>0</value_1> <value_2>1</value_2> </length> <alias>Gelöscht</alias> </field> <field f_name="bValidated"> <type>enum</type> <length> <value_1>0</value_1> <value_2>1</value_2> </length> <alias>Passwort validiert</alias> </field> </table> <table tbl_name="tcom_dateadded"> <field f_name="ixDateadded" primary="1"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>DateaddedID</alias> </field> <field f_name="fixKey"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>ForeignID</alias> </field> <field f_name="fixTable"> <type>enum</type> <length> <value_1>tdta_user</value_1> <value_2>tdta_game</value_2> <value_3>tdta_cheat</value_3> <value_3>tdta_officecontact</value_3> </length> <alias>ForeignTable</alias> </field> <field f_name="iDateadded"> <type>int</type> <length>10</length> <minlength>10</minlength> <alias>Hinzugefügt am</alias> </field> <field f_name="iDatedeleted"> <type>int</type> <length>10</length> <minlength>10</minlength> <alias>Gelöscht am</alias> </field> <field f_name="iDatechanged"> <type>int</type> <length>10</length> <minlength>10</minlength> <alias>Zuletzt geändert am</alias> </field> <field f_name="fixAddedby"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>Hinzugefügt von</alias> </field> <field f_name="fixChangedby"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>Geändert von</alias> </field> <field f_name="fixDeletedby"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>Gelöscht von</alias> </field> </table> <table tbl_name="tkey_address"> <field f_name="ixAddress" primary="1"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>AddressID</alias> </field> <field f_name="cCity"> <type>string</type> <length>50</length> <minlength>0</minlength> <alias>Stadt</alias> </field> <field f_name="cStreet"> <type>string</type> <length>60</length> <minlength>0</minlength> <alias>Strasse</alias> </field> <field f_name="cPostcode"> <type>string</type> <length>10</length> <minlength>0</minlength> <alias>PLZ</alias> </field> <field f_name="cTelephone"> <type>string</type> <length>50</length> <minlength>0</minlength> <alias>Telefon</alias> </field> <field f_name="fixCountry"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> <alias>CountryID</alias> </field> </table> <table tbl_name="tkey_email"> <field f_name="ixEmail" primary="1"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>EmailID</alias> </field> <field f_name="cEmail"> <type>string</type> <length>80</length> <minlength>8</minlength> <alias>Email</alias> </field> </table> <table tbl_name="tkey_membercard"> <field f_name="ixMembercard" primary="1"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> <alias>MembercardID</alias> </field> <field f_name="cFavurl1"> <type>string</type> <length>150</length> <minlength>0</minlength> <alias>Lieblingsurl 1</alias> </field> <field f_name="cFavurl2"> <type>string</type> <length>150</length> <minlength>0</minlength> <alias>Lieblingsurl 2</alias> </field> <field f_name="cFavurl3"> <type>string</type> <length>150</length> <minlength>0</minlength> <alias>Lieblingsurl 3</alias> </field> <field f_name="fixFavgametype1"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> <alias>Lieblings Game-Typ 1</alias> </field> <field f_name="fixFavgametype2"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> <alias>Lieblings Game-Typ 2</alias> </field> <field f_name="cHomepage"> <type>string</type> <length>150</length> <minlength>0</minlength> <alias>Homepage</alias> </field> <field f_name="sDisplay"> <type>set</type> <length> <value_1>null</value_1> <value_2>name</value_2> <value_3>firstname</value_3> <value_4>location</value_4> <value_5>birthday</value_5> </length> <alias>Display Daten</alias> </field> <field f_name="cOccupation"> <type>string</type> <length>80</length> <minlength>0</minlength> <alias>Beschäftigung</alias> </field> </table> <table tbl_name="tfix_country"> <field f_name="ixCountry" primary="1"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> <alias>CountryID</alias> </field> <field f_name="cName"> <type>string</type> <length>40</length> <minlength>3</minlength> </field> </table> <table tbl_name="tfix_gametype"> <field f_name="ixGametype" primary="1"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="cName"> <type>string</type> <length>50</length> <minlength>3</minlength> </field> </table> <table tbl_name="tfix_systemtype"> <field f_name="ixSystemtype" primary="1"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="cName"> <type>string</type> <length>30</length> <minlength>3</minlength> </field> <field f_name="cOldsystemtype"> <type>string</type> <length>10</length> <minlength>3</minlength> </field> <field f_name="cShortsystemtype"> <type>string</type> <length>20</length> <minlength>3</minlength> </field> </table> <table tbl_name="tdta_officecontact"> <field f_name="ixOfficecontact" primary="1"> <type>int</type> <length>6</length> <minlength>6</minlength> <zerofill>1</zerofill> </field> <field f_name="fixCompany"> <type>int</type> <length>6</length> <minlength>6</minlength> <zerofill>1</zerofill> </field> <field f_name="fixCountry"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="cCity"> <type>string</type> <length>90</length> <minlength>3</minlength> </field> <field f_name="cPostcode"> <type>string</type> <length>10</length> <minlength>3</minlength> </field> <field f_name="cOfficeposition"> <type>string</type> <length>100</length> <minlength>3</minlength> </field> <field f_name="cOfficedepartment"> <type>string</type> <length>100</length> <minlength>3</minlength> </field> <field f_name="cTelephone"> <type>string</type> <length>30</length> <minlength>3</minlength> </field> <field f_name="cFax"> <type>string</type> <length>30</length> <minlength>3</minlength> </field> <field f_name="cStreet"> <type>string</type> <length>100</length> <minlength>3</minlength> </field> <field f_name="cFirstname"> <type>string</type> <length>30</length> <minlength>3</minlength> </field> <field f_name="cName"> <type>string</type> <length>30</length> <minlength>3</minlength> </field> <field f_name="cMobilephone"> <type>string</type> <length>30</length> <minlength>3</minlength> </field> <field f_name="cICQ"> <type>string</type> <length>15</length> <minlength>3</minlength> </field> <field f_name="cEmail"> <type>string</type> <length>80</length> <minlength>3</minlength> </field> <field f_name="bDeleted"> <type>set</type> <length> <value_1>0</value_1> <value_2>1</value_2> </length> </field> </table> <table tbl_name="tfix_company"> <field f_name="ixCompany" primary="1"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="fixParentcompany"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="cName"> <type>string</type> <length>100</length> <minlength>3</minlength> </field> <field f_name="cShortname"> <type>string</type> <length>30</length> <minlength>2</minlength> </field> <field f_name="cHomepage_de"> <type>string</type> <length>100</length> <minlength>2</minlength> </field> <field f_name="cHomepage_us"> <type>string</type> <length>100</length> <minlength>2</minlength> </field> <field f_name="cTelephone"> <type>string</type> <length>30</length> <minlength>2</minlength> </field> </table> <table tbl_name="tdta_game"> <field f_name="ixGame" primary="1"> <type>int</type> <length>6</length> <minlength>6</minlength> <zerofill>1</zerofill> </field> <field f_name="fixGamedescription"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="fixGametype"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="fixSystemtype"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="cName"> <type>string</type> <length>60</length> <minlength>1</minlength> </field> <field f_name="cKeyword"> <type>string</type> <length>150</length> <minlength>1</minlength> </field> <field f_name="iReleasedate"> <type>int</type> <length>10</length> <minlength>7</minlength> </field> <field f_name="eReleasetype"> <type>enum</type> <length> <value_1>day</value_1> <value_2>month</value_2> <value_3>year</value_3> <value_4>quarter</value_4> </length> </field> <field f_name="bReleasefinal"> <type>enum</type> <length> <value_1>0</value_1> <value_2>1</value_2> </length> </field> <field f_name="eUSK"> <type>enum</type> <length> <value_1>0</value_1> <value_2>6</value_2> <value_3>12</value_3> <value_4>16</value_4> <value_5>18</value_5> <value_6>?</value_6> </length> </field> <field f_name="bBPJSindex"> <type>enum</type> <length> <value_1>0</value_1> <value_2>1</value_2> </length> </field> <field f_name="bDeleted"> <type>enum</type> <length> <value_1>0</value_1> <value_2>1</value_2> </length> </field> </table> <table tbl_name="tkey_gamedescription"> <field f_name="ixGamedescription" primary="1"> <type>int</type> <length>6</length> <minlength>6</minlength> <zerofill>1</zerofill> </field> <field f_name="txtDescription"> <type>string</type> <length>65535</length> <minlength>3</minlength> </field> <field f_name="cRequirements"> <type>string</type> <length>255</length> <minlength>3</minlength> </field> </table> <table tbl_name="tfix_cheattype"> <field f_name="ixCheattype" primary="1"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="cName"> <type>string</type> <length>30</length> <minlength>3</minlength> </field> </table> <table tbl_name="tfix_cheatgroup"> <field f_name="ixCheatgroup" primary="1"> <type>int</type> <length>6</length> <minlength>6</minlength> <zerofill>1</zerofill> </field> <field f_name="fixGame"> <type>int</type> <length>6</length> <minlength>6</minlength> <zerofill>1</zerofill> </field> <field f_name="cName"> <type>string</type> <length>60</length> <minlength>3</minlength> </field> </table> <table tbl_name="tdta_cheat"> <field f_name="ixCheat" primary="1"> <type>int</type> <length>6</length> <minlength>6</minlength> <zerofill>1</zerofill> </field> <field f_name="fixGame"> <type>int</type> <length>6</length> <minlength>6</minlength> <zerofill>1</zerofill> </field> <field f_name="fixCheattype"> <type>int</type> <length>3</length> <minlength>3</minlength> <zerofill>1</zerofill> </field> <field f_name="fixUser"> <type>int</type> <length>7</length> <minlength>7</minlength> <zerofill>1</zerofill> </field> <field f_name="fixCheatgroup"> <type>int</type> <length>6</length> <minlength>6</minlength> <zerofill>1</zerofill> </field> <field f_name="eOrigin"> <type>set</type> <length> <value_1>stips_editorial</value_1> <value_2>stips_user</value_2> </length> </field> <field f_name="cHeadline"> <type>string</type> <length>100</length> <minlength>3</minlength> </field> <field f_name="cSource"> <type>string</type> <length>50</length> <minlength>3</minlength> </field> <field f_name="cSourcelink"> <type>string</type> <length>50</length> <minlength>3</minlength> </field> <field f_name="txtCheat"> <type>string</type> <length>65535</length> <minlength>1</minlength> </field> </table> </database> </datastructure> <!-- SNAP --!>