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 the user

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

[Asterisk-Users] Asterisk MySQL Blobs

2005-03-07 Thread vgrskovic
Hello Folks, 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

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

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: asterisk-users@lists.digium.com Sent: Monday, March 07, 2005 2:05 PM Subject: [Asterisk-Users] Asterisk MySQL Blobs Hello Folks, Has

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

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 but I would

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 short so

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 by the file

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 verified whether the

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