X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FManual%2FTroubleshooting.pod;h=747caf90c4d2054f31d64c04262fe18cce79afd7;hb=9361b05d319e60314bf2caff1e96ff3c388a50bb;hp=18fb89edc42292a591391d78a7361b3472f121ac;hpb=45a054fc8abfb26bbddb24afbfd3f2f89933b0da;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Manual/Troubleshooting.pod b/lib/DBIx/Class/Manual/Troubleshooting.pod index 18fb89e..747caf9 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 @@ -149,22 +149,14 @@ 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 row 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. -=head2 create_ddl_dir does not produce DDL for MySQL views - -L does not create DDL for MySQL views if it doesn't know you -are using mysql version 5.000001 or higher. To explicity set this version, add -C to the C in the C<%sqlt> options. - - $schema->create_ddl_dir(['MySQL'], '1.0', './sql/', undef, { producer_args => { mysql_version => 5.000058 } }) - =cut