pastvne
Bruce Decker
Hi Guys:
I have a fabrik site that I developed on a shared linux server. All is working athough I'm wrestling with some performance issues. I purchased a VPS cloud server from my hosting company and used Akeeba to backup the site and move it to the new VPS server.
The site is up and working in most respects but I have one issue with my large list when it is view unfiltered. Basically, it goes off to fetch and then in about three seconds it whitescreens and never comes back. I turned on FabrikDebug and I'm getting this which I think indicates that the process is failing during the join. I've watched the linux top listing and I'm nowhere close to full on memory, disk or CPU.
[fieldset]renderost
Array
(
)
joins
Array
(
[0] => stdClass Object
(
[id] => 124
[list_id] => 0
[element_id] => 776
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 65
[params] => {"join-label":"document_id","type":"element","pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes
[keytable] => bpi_edoc_document_control
)
[1] => stdClass Object
(
[id] => 243
[list_id] => 37
[element_id] => 0
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes_0
[keytable] => bpi_edoc_document_control
)
[2] => stdClass Object
(
[id] => 263
[list_id] => 0
[element_id] => 1290
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => bpi_edoc_roles
[table_key] => role
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"description","type":"element","pk":"`bpi_edoc_roles`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_roles
[keytable] => bpi_edoc_doctypes_0
)
[3] => stdClass Object
(
[id] => 266
[list_id] => 0
[element_id] => 1291
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => jos_content
[table_key] => template
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"title","type":"element","pk":"`jos_content`.`id`"}
[canUse] => 1
[table_join_alias] => jos_content
[keytable] => bpi_edoc_doctypes_0
)
)
joins
Array
(
[0] => stdClass Object
(
[id] => 124
[list_id] => 0
[element_id] => 776
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 65
[params] => {"join-label":"document_id","type":"element","pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes
[keytable] => bpi_edoc_document_control
)
[1] => stdClass Object
(
[id] => 243
[list_id] => 37
[element_id] => 0
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes_0
[keytable] => bpi_edoc_document_control
)
[2] => stdClass Object
(
[id] => 263
[list_id] => 0
[element_id] => 1290
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => bpi_edoc_roles
[table_key] => role
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"description","type":"element","pk":"`bpi_edoc_roles`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_roles
[keytable] => bpi_edoc_doctypes_0
)
[3] => stdClass Object
(
[id] => 266
[list_id] => 0
[element_id] => 1291
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => jos_content
[table_key] => template
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"title","type":"element","pk":"`jos_content`.`id`"}
[canUse] => 1
[table_join_alias] => jos_content
[keytable] => bpi_edoc_doctypes_0
)
)
filter array: after querystring filters
Array
(
)
filter array: after session filters
Array
(
)
filter array: search form
Array
(
)
filter array: before onGetPostFilter
Array
(
)
filter array: after onGetPostFilter
Array
(
)
filter array: after getpostfilters
Array
(
)
filter array
Array
(
)
filter array: after access taken into account
Array
(
)
filter:request
Array
(
)
prefilters
Array
(
)
filter:request keys
Array
(
)
tablemodel::getFilterArray middle
Array
(
)
table:mergeJoinedData get ids
SELECT DISTINCT `bpi_edoc_document_control`.`id` AS __pk_val0, `bpi_edoc_doctypes`.`id` AS __pk_val1 FROM `bpi_edoc_document_control` LEFT JOIN `bpi_edoc_doctypes` AS `bpi_edoc_doctypes` ON `bpi_edoc_doctypes`.`id` = `bpi_edoc_document_control`.`doc_type` LEFT JOIN `bpi_edoc_doctypes` AS `bpi_edoc_doctypes_0` ON `bpi_edoc_doctypes_0`.`id` = `bpi_edoc_document_control`.`doc_type` LEFT JOIN `bpi_edoc_roles` AS `bpi_edoc_roles` ON `bpi_edoc_roles`.`id` = `bpi_edoc_doctypes_0`.`role` LEFT JOIN `jos_content` AS `jos_content` ON `jos_content`.`id` = `bpi_edoc_doctypes_0`.`template` ORDER BY `bpi_edoc_document_control`.`id` DESC[/fieldset]
and that's where it stops...
I have a fabrik site that I developed on a shared linux server. All is working athough I'm wrestling with some performance issues. I purchased a VPS cloud server from my hosting company and used Akeeba to backup the site and move it to the new VPS server.
The site is up and working in most respects but I have one issue with my large list when it is view unfiltered. Basically, it goes off to fetch and then in about three seconds it whitescreens and never comes back. I turned on FabrikDebug and I'm getting this which I think indicates that the process is failing during the join. I've watched the linux top listing and I'm nowhere close to full on memory, disk or CPU.
[fieldset]renderost
Array
(
)
joins
Array
(
[0] => stdClass Object
(
[id] => 124
[list_id] => 0
[element_id] => 776
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 65
[params] => {"join-label":"document_id","type":"element","pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes
[keytable] => bpi_edoc_document_control
)
[1] => stdClass Object
(
[id] => 243
[list_id] => 37
[element_id] => 0
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes_0
[keytable] => bpi_edoc_document_control
)
[2] => stdClass Object
(
[id] => 263
[list_id] => 0
[element_id] => 1290
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => bpi_edoc_roles
[table_key] => role
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"description","type":"element","pk":"`bpi_edoc_roles`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_roles
[keytable] => bpi_edoc_doctypes_0
)
[3] => stdClass Object
(
[id] => 266
[list_id] => 0
[element_id] => 1291
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => jos_content
[table_key] => template
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"title","type":"element","pk":"`jos_content`.`id`"}
[canUse] => 1
[table_join_alias] => jos_content
[keytable] => bpi_edoc_doctypes_0
)
)
joins
Array
(
[0] => stdClass Object
(
[id] => 124
[list_id] => 0
[element_id] => 776
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 65
[params] => {"join-label":"document_id","type":"element","pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes
[keytable] => bpi_edoc_document_control
)
[1] => stdClass Object
(
[id] => 243
[list_id] => 37
[element_id] => 0
[join_from_table] => bpi_edoc_document_control
[table_join] => bpi_edoc_doctypes
[table_key] => doc_type
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"pk":"`bpi_edoc_doctypes`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_doctypes_0
[keytable] => bpi_edoc_document_control
)
[2] => stdClass Object
(
[id] => 263
[list_id] => 0
[element_id] => 1290
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => bpi_edoc_roles
[table_key] => role
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"description","type":"element","pk":"`bpi_edoc_roles`.`id`"}
[canUse] => 1
[table_join_alias] => bpi_edoc_roles
[keytable] => bpi_edoc_doctypes_0
)
[3] => stdClass Object
(
[id] => 266
[list_id] => 0
[element_id] => 1291
[join_from_table] => bpi_edoc_doctypes_0
[table_join] => jos_content
[table_key] => template
[table_join_key] => id
[join_type] => left
[group_id] => 102
[params] => {"join-label":"title","type":"element","pk":"`jos_content`.`id`"}
[canUse] => 1
[table_join_alias] => jos_content
[keytable] => bpi_edoc_doctypes_0
)
)
filter array: after querystring filters
Array
(
)
filter array: after session filters
Array
(
)
filter array: search form
Array
(
)
filter array: before onGetPostFilter
Array
(
)
filter array: after onGetPostFilter
Array
(
)
filter array: after getpostfilters
Array
(
)
filter array
Array
(
)
filter array: after access taken into account
Array
(
)
filter:request
Array
(
)
prefilters
Array
(
)
filter:request keys
Array
(
)
tablemodel::getFilterArray middle
Array
(
)
table:mergeJoinedData get ids
SELECT DISTINCT `bpi_edoc_document_control`.`id` AS __pk_val0, `bpi_edoc_doctypes`.`id` AS __pk_val1 FROM `bpi_edoc_document_control` LEFT JOIN `bpi_edoc_doctypes` AS `bpi_edoc_doctypes` ON `bpi_edoc_doctypes`.`id` = `bpi_edoc_document_control`.`doc_type` LEFT JOIN `bpi_edoc_doctypes` AS `bpi_edoc_doctypes_0` ON `bpi_edoc_doctypes_0`.`id` = `bpi_edoc_document_control`.`doc_type` LEFT JOIN `bpi_edoc_roles` AS `bpi_edoc_roles` ON `bpi_edoc_roles`.`id` = `bpi_edoc_doctypes_0`.`role` LEFT JOIN `jos_content` AS `jos_content` ON `jos_content`.`id` = `bpi_edoc_doctypes_0`.`template` ORDER BY `bpi_edoc_document_control`.`id` DESC[/fieldset]
and that's where it stops...