The field {nodewords}.id should be changed in an integer; this would allow to make the executed query faster.

CommentFileSizeAuthor
#2 nodewords_0961B011.patch12.54 KBavpaderno

Comments

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: Change {nodewords}.id in an integer » {nodewords_custom}.path is copied in {nodewords}.id
Version: » 6.x-1.x-dev
Component: Database schema » Code
Category: task » bug

I am changing the referring version, and the category because this is a bug. The field {nodewords_custom}.path, which can contain more than one path, is copied in a field that can contain less characters.It
would be preferable to use {nodewords_custom}.pid as ID.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
StatusFileSize
new nodewords_0961B011.patch12.54 KB

The attached patch resolves the problem, and changes also the data type used by for the field type, which should be used as integer because it uses only a limited number of distinct values.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Active » Fixed

The code has been changed, and committed in CVS.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.