|
Hello !
I'm trying to implement a Event Log on my vb.net Application + Sql server database.
I have an Event table that keep all the event that are happening when using the database , and where it's necessary the event record can contain link to the Table and record related with this event.
The idea is working , but I have 2 problems:
1) The Event table is growing very fast . Do you think it's better to keep inside my main database , or to move to another database ?
2) I need a suggestion about the events that are related to Deletions. Since I can't keep a link to these records ( because they are deleted ) , how can I inform the users about the deleted record related to this event ?
Thank you !
|
|
|
|
|
satc wrote: 1) The Event table is growing very fast . Do you think it's better to keep
inside my main database , or to move to another database ? I'd put it in a separate database on the server, with its own backup policy. I'd also recommend to not broadcast "every" message, but to have the severity as a setting.
satc wrote: 2) I need a suggestion about the events that are related to Deletions. Since I
can't keep a link to these records ( because they are deleted ) , how can I
inform the users about the deleted record related to this event ? "Record X has been deleted". The only way to say what was in record X is by keeping a copy and not deleting it.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Quote: I'd also recommend to not broadcast "every" message, but to have the severity as a setting.
Can you explain this , because I don't understand it.
Thank you !
|
|
|
|
|
You are now sending multiple types of messages, and they flood your table?
If you don't need all those messages everytime, then you might want to consider to "not send" them until you throw a switch somewhere. As in, only get the messages you are interested in, when they are relevant.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Still I'm not clear what you are saying.
I store any kinds of events like :
- A new record is added
- A record is deleted
- A record is modified
- A report is created
- A database backup/restore is made
- A Import/Export is made
....
So for what kind of messages are you talking about ?
Thank you !
|
|
|
|
|
Any of the above. If you need all of those messages, then yes, you'll to reserve space for them.
Do you really "need" them all, all the time? Or could you live with the fact that "modification" messages are only sent if it was configured to send them?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I need them because the company's administrator want at any time to see what the users have done at a specific day or time.
|
|
|
|
|
Then it will become a large table; it works the same as with old fashioned books - if you are going to write a lot of them, they will require more space.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
So , your final suggestion is to keep this table inside the main database , or to have another database that will keep only the Event table ?
|
|
|
|
|
That has already been answered.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Sorry , then maybe it's a misunderstand for me.
On your first post about my question , you wrote :
Quote: I'd put it in a separate database on the server, with its own backup policy. I'd also recommend to not broadcast "every" message, but to have the severity as a setting.
Now I don't understand , why we have done all this conversation with each other ? If I should use another database , why I should not keep all the events , as you have suggested ?
Thank you !
|
|
|
|
|
satc wrote: why we have done all this conversation with each other Good question
Let's not continue.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hello,
I'm working on a Excel Add-in project in VSTO professional.
What I try to accomplish seems simple, but I cannot figure it out.
I have an excel XLL addin in resources.
On thisaddin.startup I save the xll file in folder in my documents.
What I want to do in the run time is to go and register/add this XLL addin to excel application.
Basically want to replicate following manual steps:
file->options>addins->excel addins->Browse to my folder--> add
Thanks a Lot!
|
|
|
|
|
I make setup of my project, I have crystal report in my project. When i install my setup to the users machine then this setup does not support to crystal report please tell me what is problem and that problem solution ?
|
|
|
|
|
saedawke wrote: I make setup of my project How? Using Visual Studio, InstallShield, Wise?
saedawke wrote: this setup does not support to crystal report please tell me what is problem and that problem solution CR is not installed by default, nor automatigally included. You'll need to add it to your setup as a prerequisite. Depending on what software you are using to build a setup that could be an MSI or a merge module.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I've spent the last few days looking at approaches to creating a 3D display of data points (as a small sphere) and lines (linking the spheres & as a co-ordinate axis).
I did think that DirectX was the solution, but it appears to be not supported for VB.NET under the V4 .NET Framework (?).
So I have installed XNA v4.0 as this seems to be the 'new' way of performing 3D graphics.
My goal is to have a form with a picturebox or appropriate control that I can write "data points" on to in a 3D space. I also want the user to be able to zoom and pan to view the data.
I have had no luck finding straight forward examples in VB (I'm not a c# guy). I have found examples that write circles and lines to a 2D space using XNA but nothing more complex than that.
I would really appreciate any suggestions on where to find a good VB.NET resource for XNA. A post of some sample code would be even better !
Thanks in advance.
Regards
RS
|
|
|
|
|
Getting XNA to show in a WinForm is not a simple task; 3D graphics are not part of the Framework.
You could start here[^]. There's two more options, both "not easy". You could try and find a DirectX3D tutorial, or go for OpenGL[^] - which would have my preference, as it is available on multiple platforms.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hello !
I have a List of KeyPairValues(of Integer,Boolean).
Is there any short way to detect if a specific Key exist in at least one of items of the list ?
( like a Contains method )
Thank you !
|
|
|
|
|
Have to you read the documentation on the collection you're using, or even looked at the Intellisense after you hit the "." after the Key property? There's always a Contains method on it.
|
|
|
|
|
yes , but I'm searching only for Key . If I do contains for the list of keyvaluepair , I need a keyvaluepair to search for. I know only the key . how to construct the Keyvaluepair with a key and unknown value in order to use the contains ?
|
|
|
|
|
satc wrote: yes , but I'm searching only for Key
And? That's exactly what Contains does!
satc wrote: If I do contains for the list of keyvaluepair
Wait. You have a List<KeyValuePair<something, something>> ? Why are you not using a Dictionary<key, value> ?
|
|
|
|
|
Quote: And? That's exactly what Contains does!
Ok , please can you show me an example :
Dim lst as List(of KeyValuePair(of Integer,boolean).
Please show me a example with contains to find if an item with .key=5 exist in this list.
|
|
|
|
|
You weren't very specific about what you had. If you go back to what I posted, you'll find I said "Keys property", which is itself a collection.
You don't have that. You have a List<>, which doesn't implement a Keys collection on it's own.
Instead of using a List<keyvaluepair<k, v="">>, you should being a Dictionary<k,v> which implements exactly what you want without you having to implement it yourself.
Dim myCollection As New Dictionary(Of Integer, Boolean)
...
Dim result As Boolean = myCollection.Keys.Contains(5)
|
|
|
|
|
If I would like to use dictionary , I wouldn't make the question about List.
So your response is off topic.
|
|
|
|
|
No, it's not. Why the hell are you using List<KeyValuePair<>>?
|
|
|
|