[ https://issues.apache.org/jira/browse/CASSANDRA-4418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13408571#comment-13408571 ]
shawndu edited comment on CASSANDRA-4418 at 7/7/12 4:41 AM: ------------------------------------------------------------ I know cassandra is a nosql engine. but some features in traditional sql based database engine like trigger really are very useful. it is in roadmap? for the above case, I think if cassandra let user to define some callbacks when mutations,it will be much powerful. was (Author: shawndu): I know cassandra is a nosql engine. but some features in traditional sql based database engine like trigger really are very useful. It don't know it is in roadmap? for the above case, I think if cassandra let user to define some callbacks when mutations. it will be much powerful. > Add new file Column family Type > ------------------------------- > > Key: CASSANDRA-4418 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4418 > Project: Cassandra > Issue Type: Improvement > Components: Core > Affects Versions: 1.1.2 > Environment: All > Reporter: shawndu > > Now I think cassandra's main problems is the compaction. > Our use case is: > we insert many big column value data in cassandra. column value maybe more > than 10k.for cassandra write is quiet fast. it will cause cassandra flush > memtbale data into sstable.but these data may be deleted soon. so issues > come: compaction. > I don't know the root cause. but I know the result. in this case, compaction > will make server become slow and also very high CPU and at a dangerous state. > for we have other much important process running. > I think we need a new File Column Family type. It is: > a Column value is not a byte array but a file name. the real value is in the > file. > there are some benefits: > 0 when column is inserted, just create the file. > 1 when column value is update. just replace the file. > 2 when column is deleted, just delete the file. > 3 this will save much time when compaction. > I don't know it is a good, but in my view, it is simple and can real fix the > compaction problems. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira