I am using umbraco and the database being used is SQL Server 2008.Whenever I save and publish a content a new entry is added into the cmspropertydata.Due to this the database has lacs of records.It would really be great if you could guide by letting me know on how instead of adding a new record for every save and publish how an existing record can be updated for the same topic.
I have a page that has a text box to submit text,so every time I edit and publish the text a new line is created in the database.THis further slows down the query time when used
this is by design, as you get versioning and rollback features for free. If, however, you want to clean up your db and remove redundant document versions, i'm sure you'll find some pointers if you search for it. I know there used to be packages which could deal with cleaning out the db, but not sure if there still available and whether they're fit for your umbraco version.
Huge number of entries - cmsPropertyData
Hi All,
I am using umbraco and the database being used is SQL Server 2008.Whenever I save and publish a content a new entry is added into the cmspropertydata.Due to this the database has lacs of records.It would really be great if you could guide by letting me know on how instead of adding a new record for every save and publish how an existing record can be updated for the same topic.
I have a page that has a text box to submit text,so every time I edit and publish the text a new line is created in the database.THis further slows down the query time when used
Thanks in Advance
Narayana,
this is by design, as you get versioning and rollback features for free. If, however, you want to clean up your db and remove redundant document versions, i'm sure you'll find some pointers if you search for it. I know there used to be packages which could deal with cleaning out the db, but not sure if there still available and whether they're fit for your umbraco version.
Cheers,
/Dirk
http://our.umbraco.org/projects/backoffice-extensions/falm-housekeeping
might be what you are looking for?
is working on a reply...