David M Johnson wrote:
We have XML driven name/value properties at the site-wide level.
I wonder if we should have the same thing at the website/weblog level?
- Dave
Very interesting observation Dave.
This is what RDF is about "triples". A triple would be:
{ website property value }
{ weblog property value }
{ site property value }
We could do all of them in a single table.
-Elias
On Mar 28, 2006, at 8:01 PM, Allen Gilliland wrote:
Elias Torres wrote:
David M Johnson wrote:
On Mar 28, 2006, at 1:25 PM, Elias Torres wrote:
Did you guys had a chance to look at this message?
Do you have some specific proposal for fixing this?
Breakout some of the big properties into a separate table?
huh? that sounds wacky to me. you are saying we need to move data
outside of the website table into different tables? i don't see how
that could be the case.
What if we dropped the old ignoreWords column, since it is no longer
used?
I tried without this column, but the problem still persisted. I think
I'm ok with the extra commands needed to make this work, I'm just
concerned with the size of the tuples in this table. I worry how big
we'll keep making this table with time. :(
i don't understand how this is an issue with the website table but not
the weblogentry table, which is pretty similar?
in the long term the website table will absolutely need to grow and i
don't really want to try wacky workarounds where we put things in
different tables just to work around limits in DB2. i think we should
definitely be removing any tables/columns that are no longer used and
i am fine with shortening columns that are overly long, like handle,
editorpage, and editortheme.
-- Allen
-Elias
- Dave
-Elias
Elias Torres wrote:
I was working on getting Roller working with an IBM DB2 Express-C
VMWare image. However, I found myself dealing with temporary table
spaces, complicated stuff that looked like this:
WARN 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions
- SQL
Error: -1585, SQLState: 54048
ERROR 2006-03-23 17:06:23,328 JDBCExceptionReporter:logExceptions -
[IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space
with
sufficient page size does not exist. SQLSTATE=54048
The answer (partly thanks to Matt for AppFuse wiki):
connect to roller;
create bufferpool ROLLER_BP size 1000 pagesize 32 k;
create temporary tablespace ROLLER_TEMP pagesize 32 k
managed by system
using ('roller_temp')
bufferpool ROLLER_BP;
I then went on to find out what's wrong with the source code in
the trunk? After a short discussion with a colleague at IBM (Jay
Allen), we came to the conclusion that it was around this line in
200-to-210-migration.vm:
alter table website add column blacklist $TEXT_SQL_TYPE;
The default temporary table space page size in DB2 is 4K and I
found this out because Roller is blowing that limit in queries to
the website table. In short, we have 8 varchar(255), 2 clobs (in
db2.properties each is 102400) and not counting the rest of small
fields. I think that given the discussion we had the other day on
trying to make the columns "smaller", we should also think of
making the rows smaller too. I'd rather make Roller work by
default with DB2, but this is not a big deal of a fix, however,
I'm concerned with the performance against these large tuples in
major tables like website.
Regards,
Elias
David M Johnson wrote:
Roller 2.2 RC1 is available for testing.
You can het it here:
http://people.apache.org/~snoopdave/roller-2.2-rc/
User and install docs are in the same directory.
The upgrade guide is now in Appendix A of the install guide.
- Dave
On Mar 23, 2006, at 3:40 PM, Dave Johnson wrote:
Today is the 2nd to last Thursday in the month: Release
Candidate day
http://rollerweblogger.org/wiki/Wiki.jsp?page=RollerReleasePlan
I think we have made more than enough progress for a release, so
I'm planning on putting together Roller 2.2-incubating RC1 today.
Enhancements made and bugs fixed
If you take a look at the issue list for Roller 2.2
(http://tinyurl.com/d3cwa), you'll see that we have 25 of 42
issues marked as RESOLVED. Those are the issues that Allen and I
have verified and most (if not all) of them have actually been
deployed to production sites. The remaining issues are marked as
IN PROGRESS. They have all been addressed too and for the next
week, we'll be working to verify them -- and we'd love any help
we can get.
Documentation updates
The Roller 2.2 What's New guide is up to date
http://rollerweblogger.org/wiki/Wiki.jsp?page=Roller_2.2_WhatsNew
The User Guide and Install Guide have been updated for 2.2.
http://people.apache.org/~snoopdave/roller-2.2-rc/
The Javadocs have been updated:
http://rollerweblogger.org/javadoc/
(old docs are here: http://rollerweblogger.org/javadoc_2.0)
The Velocidocs have been updated:
http://rollerweblogger.org/velocidoc/
(old docs are here: http://rollerweblogger.org/velocidoc_2.0)
- Dave
