> 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
