Skip Menu |
 

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 122544
Status: rejected
Priority: 0/
Queue: DBIx-Class

People
Owner: Nobody in particular
Requestors: francisco [...] obispo.link
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



MIME-Version: 1.0
X-Spam-Status: No, score=-1.899 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, HTML_MESSAGE=0.001] autolearn=ham
X-Mailer: MailMate (1.9.6r5347)
X-Cpan.org: This message routed through the cpan.org mail forwarding service. Please use PAUSE pause.perl.org to configure your delivery settings.
X-Spam-Flag: NO
Content-Type: multipart/alternative; boundary="=_MailMate_BDE12221-1F37-4CBC-A880-6BF1749784DE_="
Message-ID: <62FD1E70-1A72-444D-9E4C-0E59BC9B23CD [...] obispo.link>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -1.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 7D827240396 for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Wed, 19 Jul 2017 18:20:52 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id v4wWus84tL0s for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Wed, 19 Jul 2017 18:20:49 -0400 (EDT)
Received: from xx1.develooper.com (xx1.develooper.com [207.171.7.115]) by hipster.bestpractical.com (Postfix) with ESMTPS id A5320240394 for <bug-DBIx-Class [...] rt.cpan.org>; Wed, 19 Jul 2017 18:20:49 -0400 (EDT)
Received: from localhost (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with ESMTP id 1330511DFF4 for <bug-DBIx-Class [...] rt.cpan.org>; Wed, 19 Jul 2017 15:20:46 -0700 (PDT)
Received: from xx1.develooper.com (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with SMTP id F26F211DA1A for <bug-DBIx-Class [...] rt.cpan.org>; Wed, 19 Jul 2017 15:20:42 -0700 (PDT)
Received: from server.obispo.link (server.obispo.link [64.96.162.68]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by xx1.develooper.com (Postfix) with ESMTPS id 94FBE11D402 for <bug-DBIx-Class [...] rt.cpan.org>; Wed, 19 Jul 2017 15:20:42 -0700 (PDT)
Received: from [10.255.0.1] (unknown [64.96.164.227]) by server.obispo.link (Postfix) with ESMTPSA id 594DA2540 for <bug-DBIx-Class [...] rt.cpan.org.>; Wed, 19 Jul 2017 15:11:19 -0700 (PDT)
Delivered-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
Subject: view_definition is being populated on server views
Return-Path: <francisco [...] obispo.link>
X-RT-Mail-Extension: dbix-class
X-Original-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
X-PMX-Spam: Gauge=X, Probability=10%, Report=' FROM_LINK_TLD 0.5, HTML_FONT_INVISIBLE 0.1, HTML_NO_HTTP 0.1, BODYTEXTH_SIZE_10000_LESS 0, BODYTEXTP_SIZE_3000_LESS 0, BODY_SIZE_4000_4999 0, BODY_SIZE_5000_LESS 0, BODY_SIZE_7000_LESS 0, CS_SUSP_TLD_FROM 0, DATE_TZ_NA 0, NO_CTA_URI_FOUND 0, NO_URI_FOUND 0, NO_URI_HTTPS 0, SPF_NONE 0, __CT 0, __CTE 0, __CTYPE_HAS_BOUNDARY 0, __CTYPE_MULTIPART 0, __CTYPE_MULTIPART_ALT 0, __HAS_FROM 0, __HAS_HTML 0, __HAS_MSGID 0, __HAS_X_MAILER 0, __HTML_TAG_DIV 0, __MIME_HTML 0, __MIME_TEXT_H 0, __MIME_TEXT_H1 0, __MIME_TEXT_H2 0, __MIME_TEXT_P 0, __MIME_TEXT_P1 0, __MIME_TEXT_P2 0, __MIME_VERSION 0, __MSGID_APPLEMAIL 0, __SANE_MSGID 0, __SUBJ_ALPHA_END 0, __TAG_EXISTS_HTML 0, __TO_MALFORMED_2 0, __TO_NO_NAME 0, __zen.spamhaus.org_ERROR '
Date: Wed, 19 Jul 2017 15:11:18 -0700
X-Spam-Level:
X-Greylist: delayed 559 seconds by postgrey-1.34 at xx1.develooper.com; Wed, 19 Jul 2017 15:20:42 PDT
X-PMX-Version: 5.6.1.2065439, Antispam-Engine: 2.7.2.376379, Antispam-Data: 2017.7.19.221216
To: bug-DBIx-Class [...] rt.cpan.org
Content-Transfer-Encoding: 8bit
From: "Francisco Obispo" <francisco [...] obispo.link>
X-RT-Interface: Email
Content-Length: 0
content-type: text/plain; charset="utf-8"; format="flowed"; markup="markdown"
Content-Transfer-Encoding: 8bit
X-RT-Original-Encoding: utf-8
Content-Length: 1503
Download (untitled) / with headers
text/plain 1.4k
When using `dbicdump` the resulting `::Result::` package (.pm), contains the `view_definition` even though it’s a server side view. This is new behavior, and for server views that are big, the schema is inflated in size, yielding higher memory usage. If it’s not a `virtual` view the definition should be omitted, or at least provide a switch to turn this behavior off. see: ```perl __PACKAGE__->table("v_notification_user"); __PACKAGE__->result_source_instance->view_definition(" SELECT ev.created_date,\n u.id AS user_id,\n u.login AS user_login,\n a.id AS account_id,\n a.name AS account_name,\n cat.name AS category_name,\n subcat.name AS subcategory_name,\n subcat.descr AS subcategory_descr,\n sev.name AS severity_name,\n sev.id AS severity_id,\n (n.viewed_date IS NOT NULL) AS is_read,\n n.guid,\n ev.message,\n ev.object,\n ev.url,\n floor(((date_part('epoch'::text, now()) - date_part('epoch'::text, ev.created_date)) / (86400)::double precision)) AS age_days,\n n.website_show\n FROM ((((((notification_event ev\n JOIN notification n ON ((n.event_id = ev.id)))\n JOIN account a ON ((a.id = ev.account_id)))\n JOIN \"user\" u ON ((u.id = n.user_id)))\n JOIN notification_subcategory subcat ON ((ev.subcategory_id = subcat.id)))\n JOIN notification_category cat ON ((cat.id = subcat.category_id)))\n JOIN notification_severity sev ON ((sev.id = ev.severity_id)))"); ``` Best regards
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 2753
MIME-Version: 1.0
In-Reply-To: <62FD1E70-1A72-444D-9E4C-0E59BC9B23CD [...] obispo.link>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <62FD1E70-1A72-444D-9E4C-0E59BC9B23CD [...] obispo.link>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-30257-1500665850-1158.122544-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 214
Download (untitled) / with headers
text/plain 214b
This is a feature request for DBIx::Class::Schema::Loader so I'm killing the ticket in the DBIx::Class queue; let's finish discussing it on the list and then we can get a more useful ticket filed in the right spot.
MIME-Version: 1.0
X-Spam-Status: No, score=-3.899 tagged_above=-99.9 required=10 tests=[AWL=2.001, BAYES_00=-1.9, FROM_OUR_RT=-4] autolearn=ham
In-Reply-To: <rt-4.0.18-30257-1500665851-73.122544-6-0 [...] rt.cpan.org>
X-Mailer: MailMate (1.9.6r5347)
X-Cpan.org: This message routed through the cpan.org mail forwarding service. Please use PAUSE pause.perl.org to configure your delivery settings.
X-Spam-Flag: NO
X-RT-Interface: API
References: <RT-Ticket-122544 [...] rt.cpan.org> <62FD1E70-1A72-444D-9E4C-0E59BC9B23CD [...] obispo.link> <rt-4.0.18-30257-1500665851-73.122544-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <F30A484B-CBEF-4370-B07D-6B8D5CB56067 [...] obispo.link>
content-type: text/plain; charset="utf-8"; format="flowed"; markup="markdown"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -3.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id DEF042402C6 for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Fri, 21 Jul 2017 18:04:10 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id i8l17QElOMTl for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Fri, 21 Jul 2017 18:04:09 -0400 (EDT)
Received: from xx1.develooper.com (xx1.develooper.com [207.171.7.115]) by hipster.bestpractical.com (Postfix) with ESMTPS id D11E7240096 for <bug-DBIx-Class [...] rt.cpan.org>; Fri, 21 Jul 2017 18:04:09 -0400 (EDT)
Received: from localhost (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with ESMTP id 4E4B611D86F for <bug-DBIx-Class [...] rt.cpan.org>; Fri, 21 Jul 2017 15:04:08 -0700 (PDT)
Received: from xx1.develooper.com (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with SMTP id 5406E11D9E1 for <bug-DBIx-Class [...] rt.cpan.org>; Fri, 21 Jul 2017 15:04:04 -0700 (PDT)
Received: from server.obispo.link (server.obispo.link [64.96.162.68]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by xx1.develooper.com (Postfix) with ESMTPS id C5F9111D86F for <bug-DBIx-Class [...] rt.cpan.org>; Fri, 21 Jul 2017 15:03:51 -0700 (PDT)
Received: from [10.255.0.1] (unknown [64.96.164.227]) by server.obispo.link (Postfix) with ESMTPSA id CA80D2540 for <bug-DBIx-Class [...] rt.cpan.org>; Fri, 21 Jul 2017 15:03:49 -0700 (PDT)
Delivered-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
Subject: Re: [rt.cpan.org #122544] view_definition is being populated on server views
Return-Path: <francisco [...] obispo.link>
X-Original-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbix-class
Date: Fri, 21 Jul 2017 15:03:49 -0700
X-PMX-Spam: Gauge=X, Probability=10%, Report=' FROM_LINK_TLD 0.5, RCVD_FROM_IP_DATE 0.1, HTML_00_01 0.05, HTML_00_10 0.05, BODYTEXTP_SIZE_3000_LESS 0, BODYTEXTP_SIZE_400_LESS 0, BODY_SIZE_1000_LESS 0, BODY_SIZE_2000_LESS 0, BODY_SIZE_300_399 0, BODY_SIZE_5000_LESS 0, BODY_SIZE_7000_LESS 0, CS_SUSP_TLD_FROM 0, DATE_TZ_NA 0, IN_REP_TO 0, LEGITIMATE_SIGNS 0, MSG_THREAD 0, REFERENCES 0, SINGLE_URI_IN_BODY 0, SPF_NONE 0, URI_ENDS_IN_HTML 0, URI_WITH_PATH_ONLY 0, __ANY_URI 0, __BOUNCE_CHALLENGE_SUBJ 0, __BOUNCE_NDR_SUBJ_EXEMPT 0, __CP_URI_IN_BODY 0, __CT 0, __CT_TEXT_PLAIN 0, __FORWARDED_MSG 0, __HAS_FROM 0, __HAS_MSGID 0, __HAS_X_MAILER 0, __HTTPS_URI 0, __IN_REP_TO 0, __MIME_TEXT_ONLY 0, __MIME_TEXT_P 0, __MIME_TEXT_P1 0, __MIME_VERSION 0, __MSGID_APPLEMAIL 0, __NO_HTML_TAG_RAW 0, __REFERENCES 0, __SANE_MSGID 0, __SINGLE_URI_TEXT 0, __SUBJ_ALPHA_END 0, __SUBJ_ALPHA_NEGATE 0, __TO_MALFORMED_2 0, __TO_NAME 0, __TO_NAME_DIFF_FROM_ACC 0, __TO_REAL_NAMES 0, __URI_IN_BODY 0, __URI_NOT_IMG 0, __URI_NO_MAILTO 0, __URI_NO_WWW 0, __URI_NS , __URI_WITH_PATH 0, __blackholes.mail-abuse.org_TIMEOUT , __zen.spamhaus.org_ERROR '
X-Spam-Level:
X-PMX-Version: 5.6.1.2065439, Antispam-Engine: 2.7.2.376379, Antispam-Data: 2017.7.21.215415
To: "Matt S Trout via RT" <bug-DBIx-Class [...] rt.cpan.org>
From: "Francisco Obispo" <francisco [...] obispo.link>
RT-Message-ID: <rt-4.0.18-13396-1500674651-365.122544-0-0 [...] rt.cpan.org>
Content-Length: 363
Download (untitled) / with headers
text/plain 363b
Sounds good, thanks On 21 Jul 2017, at 12:37, Matt S Trout via RT wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=122544 > > > This is a feature request for DBIx::Class::Schema::Loader so I'm > killing the ticket in the DBIx::Class queue; let's finish discussing > it on the list and then we can get a more useful ticket filed in the > right spot.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.