|
|
Rank: Devotee
Joined: 7/24/2006
Posts: 249
|
we recently had major issues with our database reaching a size that crippled our website.
after rebuilding and cleaning database we now have a database of 32MB
so re-installed the umbracostats and now each day the stats add approx 1MB which doesn't sound like much but after a year it's 300MB
Is there any way to have the stats write to a different database?
|
|
Rank: Fanatic
Joined: 7/20/2006
Posts: 488
Location: NL
|
Yes, just add an extra entry to your web.config: Code: <add key="umbracoStatDbDSN" value="Server=SERVER;Database=DATABASE;User ID=USER;Password=PASSWORD;Trusted_Connection=False" /> PeterD
Working on an events-calendar with recursion. Post requests on my blog!
|
|
Rank: Devotee
Joined: 7/24/2006
Posts: 249
|
thanks Peter,
but how do I tell umbracostats to use the new database?
|
|
Rank: Fanatic
Joined: 7/20/2006
Posts: 488
Location: NL
|
First create a new database. I'm not sure if you need to define the 2 tables (umbracoStatEntry and umbracoStatSession) for stats manually.....havent tested that but will do later tonight when I am home.
After that, add that key to your web.config and let it point to the new database, the stats will be written to the new database then.
I hope this is clear or maybe I misunderstood you.....
PeterD
Working on an events-calendar with recursion. Post requests on my blog!
|
|
Rank: Devotee
Joined: 7/24/2006
Posts: 249
|
Yes we are mis-understanding more likely I have not been clear.
what I would like to do is use two separate databases, one for the regular website and all the content etc and another totally separate database just for the umbracostats, This way if the information gets too much too fast we can simply replace/overwrite the stats database with a empty clean one and don't have to worry about it touching the actual content of the website.
|
|
Rank: Devotee
Joined: 7/24/2006
Posts: 249
|
OK, It was me that was mis-understanding, I did not realize adding the above key to web.config would allow this. I have not come across this documentation anywhere, including the umbracostats manual install archive.
So I created a new database "umbracoSTATS" and added the "umbracouser" to it the same as our cms database.
then went to the umbracostatentry table in SQL manager -> right click on database ->script table -> create to -> new query .
Then in query view choose "umbracoSTATS" from dropdown and change sql commands to
"USE umbracoSTATS" and it all runs clean and creates the appropriate tables in the new database.
Then at a command prompt "IISRESET"
goto umbraco console and look at stats and see big fat "Server Error" I lost the clipboard but it was about writing/reading the umbracoistatenry database table...
any ideas?
any help please?
thanks
|
|
Rank: Fanatic
Joined: 7/25/2006
Posts: 424
Location: Silkeborg, Denmark
|
To everyone subscribed to this thread: Please go read this post. We are trying to figure out who's interested in this project, so we can figure out if it needs a different priority. /SoerenS
Brug for råd til hvordan du driver en god webshop? / Need advice on how to run an effective webshop?
|
|
|
Guest |