GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  CATALYST::PLUGIN::AUTOCRUD::MANUAL::LIMITATIONS (3)

.ds Aq ’

NAME

Catalyst::Plugin::AutoCRUD::Manual::Limitations - Noted Limitations

CONTENTS

Time Zone settings are lost during SELECT/UPDATE

Database fields of types such as (PostgreSQL) timestamp with time zone will be displayed with a date and time picker, but you’ll lose the time zone’s UTC offset value, sorry. This could be fixed and retained through an improved UI widget, for example.

Performance on large datasets with relations

Take care when providing access to large datasets. If the user choses to view all records (in the ExtJS2 frontend), and these records have relations, many additional rows will be fetched from the database when AutoCRUD follows those relations. The response of the site is likely to be severely degraded.

This is by design, as the purpose of this plugin is first and foremost to provide administrators and developers with easy access to data sources. The author is happy if you wish to install the plugin for end-users, but please bear in mind the above limitation.

One possible workaround for DBIx::Class storage is to create new ResultSet classes which omit defining the relations (and even some data columns, if you wish). Configure AutoCRUD with a Site which hides all ResultSet classes except these, and then unecessary data will not be retrieved nor relations followed.

Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 CATALYST::PLUGIN::AUTOCRUD::MANUAL::LIMITATIONS (3) 2013-05-01

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.