Re: anyone willing to share proper syslog SQL schema & data typing?

"Marcus J. Ranum" <[email protected]>
Newsgroups gmane.comp.sysutils.loganalysis
Message-ID <[email protected]> 
Jason Haar wrote:
>our current file-based structure is really quite slow - so SQL sounds like the way
>to go.

Is it slow for inserts, or just slow for searching? Because if inserts
are currently a problem, using SQL is going to make things worse
rather than better. Obviously, a database will make searching a lot
faster depending on what fields you set up as indexed.

mjr.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.