X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FManual%2FTroubleshooting.pod;h=f76934ec2c2f72b28861c58d9ae07bc9494db55d;hb=47d7b769c034e04989840b1efc2f5991518cff23;hp=820359d7c325ea08f6d1133cee7b98375d44aebe;hpb=48580715af3072905f2c71dc27e7f70f21a11338;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Manual/Troubleshooting.pod b/lib/DBIx/Class/Manual/Troubleshooting.pod index 820359d..f76934e 100644 --- a/lib/DBIx/Class/Manual/Troubleshooting.pod +++ b/lib/DBIx/Class/Manual/Troubleshooting.pod @@ -51,7 +51,7 @@ L version 1.50 and L 1.43 are known to work. There's likely a syntax error in the table class referred to elsewhere in this error message. In particular make sure that the package -declaration is correct. For example, for a schema C< MySchema > +declaration is correct. For example, for a schema C< MySchema > you need to specify a fully qualified namespace: C< package MySchema::MyTable; >. =head2 syntax error at or near "" ... @@ -96,7 +96,7 @@ up with the following errors: 2) syntax error at or near "user" - due to "user" in the JOIN clause The solution is to enable quoting - see -L for +L for details. =head2 column "foo DESC" does not exist ... @@ -112,7 +112,7 @@ should be written as: $rs->search( {}, { order_by => { -desc => 'name' } } ); For more ways to express order clauses refer to -L +L =head2 Perl Performance Issues on Red Hat Systems @@ -134,7 +134,7 @@ with full current updates will not be subject to this problem):- This issue is due to perl doing an exhaustive search of blessed objects under certain circumstances. The problem shows up as performance -degradation exponential to the number of L row objects in +degradation exponential to the number of L result objects in memory, so can be unnoticeable with certain data sets, but with huge performance impacts on other datasets. @@ -149,11 +149,11 @@ L =head2 Excessive Memory Allocation with TEXT/BLOB/etc. Columns and Large LongReadLen -It has been observed, using L, that creating a L -object which includes a column of data type TEXT/BLOB/etc. will allocate -LongReadLen bytes. This allocation does not leak, but if LongReadLen -is large in size, and many such row objects are created, e.g. as the -output of a ResultSet query, the memory footprint of the Perl interpreter +It has been observed, using L, that creating a L +object which includes a column of data type TEXT/BLOB/etc. will allocate +LongReadLen bytes. This allocation does not leak, but if LongReadLen +is large in size, and many such result objects are created, e.g. as the +output of a ResultSet query, the memory footprint of the Perl interpreter can grow very large. The solution is to use the smallest practical value for LongReadLen.