Re: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-08 Thread Paul Traue, Jr.
In ReiserFS3, the performance loss for a directory containing 10's of thousands of files is negligible. I've personally had directories with 70,000+ files in them, and the performance has been stellar. Most traditional unix file systems break down around 5k-10k files, but I'd trust ReiserFS w

RE: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-08 Thread Adam Goryachev
On Mon, 2005-03-07 at 13:30 -0800, beonice wrote: > --- Colin Anderson <[EMAIL PROTECTED]> > wrote: > The problem I suspect will arise is the number of > inodes allowed by the file system. I don't know the > exact size of the typical inode-max, but this will > also presumably become an issue when t

Re: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-07 Thread Paul
Steven Critchfield wrote: On Mon, 2005-03-07 at 16:06 -0500, Eric wrote: Hi Vinko, MySQL blobs will store binary data, so you should be OK there. I'd focus on whether or not storing the data in a variable is a good idea. Typically, with any programming language, it's good practice to keep varia

RE: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-07 Thread beonice
--- Steven Critchfield <[EMAIL PROTECTED]> wrote: > On Mon, 2005-03-07 at 13:30 -0800, beonice wrote: > > ... snip ... > > Would it help to split the db off to a separate > server > > (that should reduce the CPU load on the asterisk > > server)? > > > > Any other alternatives? Anyone verifi

RE: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-07 Thread Steven Critchfield
On Mon, 2005-03-07 at 13:30 -0800, beonice wrote: > --- Colin Anderson <[EMAIL PROTECTED]> > wrote: > > IMO, use filesystem for files. Use DB for DB. Put a > > pointer in a field to > > the file. Your DB will love you for it. > > The problem I suspect will arise is the number of > inodes allowed

Re: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-07 Thread Steven Critchfield
On Mon, 2005-03-07 at 16:06 -0500, Eric wrote: > Hi Vinko, > > MySQL blobs will store binary data, so you should be OK there. I'd > focus on whether or not storing the data in a variable is a good idea. > Typically, with any programming language, it's good practice to > keep variable lengths shor

RE: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-07 Thread beonice
--- Colin Anderson <[EMAIL PROTECTED]> wrote: > >Has anyone had production experience using * w/ > MySQL Blobs to store sound > files? The >application I am working on requires > all user data resides in a > database. I am currently >reading/writing the > files to disk via a phpagi > scripts bu

Re: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-07 Thread Eric
Hi Vinko, MySQL blobs will store binary data, so you should be OK there. I'd focus on whether or not storing the data in a variable is a good idea. Typically, with any programming language, it's good practice to keep variable lengths short so you aren't passing the variable itself between functio

Re: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-07 Thread Matthew Boehm
Checkout CVS. There is now support for storing voicemail sound files in DB with ODBC. -Matthew - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, March 07, 2005 2:05 PM Subject: [Asterisk-Users] Asterisk & MySQL Blobs > Hello Folks, > > Has anyone had production experien

RE: [Asterisk-Users] Asterisk & MySQL Blobs

2005-03-07 Thread Colin Anderson
>Has anyone had production experience using * w/ MySQL Blobs to store sound files? The >application I am working on requires all user data resides in a database. I am currently >reading/writing the files to disk via a phpagi scripts but I would love to read the blob into a> variable in the dial