On Mar 21, 2012, at 4:29 PM, Keshav Kini wrote: > William Stein <wst...@gmail.com> writes: >> Is there a report that lists "tickets needing work that I *attached a >> patch to*"? > > As I recall, David was having trouble with those kinds of queries, > because attachments store the ticket number they're on using a string > field, whereas ticket IDs themselves are integers for some reason. So a > lot of casting goes on, making the query super slow. (The reason > attachments store the ticket number as a string is that attachments can > also be made to, for example, wiki pages.)
It seems like it should be possible unless the person has a huge number of tickets needing work and a huge number of patches, though I don't know anything about how the tables are stored, so I could be very wrong. Are we using the same schema as at http://trac.edgewall.org/wiki/TracDev/DatabaseSchema, or do we have modifications of our own? Actually, I'm not sure why I'm asking since I don't really have DBA skills, and I don't want to be a trac admin. :-) Thanks to those who have this (often thankless) job. -Ivan -- To post to this group, send an email to sage-devel@googlegroups.com To unsubscribe from this group, send an email to sage-devel+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sage-devel URL: http://www.sagemath.org
