That is a very intresting patch... i'll see if I can test it. bkw
----- Original Message ----- From: "David Creemer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 07, 2004 3:09 PM Subject: Re: [Asterisk-Users] CDR records into SQLite > > On Jul 7, 2004, at 6:59 AM, brian wrote: > > > I don't get why we need this. cdr_odbc.c has this covered. Also Josh > > has > > some info on how to compile cdr_odbc using iodbc libs instead of > > unixodbc. > > > > Well not quite. As shipped I couldn't make cdr_odbc.c work with SQLite. > I've patched it, and it works well for my purposes. If anyone wants to > submit the patch please feel free to do so. I currently have CDR's > logged via unixodbc-2.2.8 and the sqliteodbc-0.62 driver. > > See http://www.sonic.net/~dcreemer/cdr_odbc-update.patch > > -- David > > > cdr_sqllite.c and cdr_tds.c were both written and not needed. I'm not > > trying to discourage anyone from writing anything but why were these > > needed? > > > > http://www.unixodbc.com/drivers.html > > > > bkw > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:asterisk-users- > >> [EMAIL PROTECTED] On Behalf Of Holger Schurig > >> Sent: Wednesday, July 07, 2004 5:02 AM > >> To: [EMAIL PROTECTED] > >> Subject: Re: [Asterisk-Users] CDR records into SQLite > >> > >>> Do you know how many thousands? > >> > >> No. This depends on your machine, the type of queries you make etc. > >> > >> > >> > >> But hey, as this uses SQL, you can add and drop indexes at will, even > >> while Asterisk has the cdr.db file open. > >> > >> For example, when you need to select quite often by the destination > >> and > >> you think that is slow, then just create an index on-the-fly: > >> > >> $ sqlite /var/log/asterisk/cdr.db > >> SQLite version 2.8.0 > >> Enter ".help" for instructions > >> sqlite> create index cdr_dst on cdr (dst); > >> sqlite> .exit > >> > >> See the documentation at http://www.sqlite.org (especially in their > >> wiki) > >> for optimizations and so on. I only have a few records in the > >> database, > >> because I don't (yet) use Asterisk in real life for the whole office. > >> > >> _______________________________________________ > >> Asterisk-Users mailing list > >> [EMAIL PROTECTED] > >> http://lists.digium.com/mailman/listinfo/asterisk-users > >> To UNSUBSCRIBE or update options visit: > >> http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > > _______________________________________________ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > _______________________________________________ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
