Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:17329 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 83757 invoked by uid 1010); 19 Jul 2005 20:24:06 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 83741 invoked from network); 19 Jul 2005 20:24:06 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 19 Jul 2005 20:24:06 -0000 X-Host-Fingerprint: 64.233.184.197 wproxy.gmail.com Linux 2.4/2.6 Received: from ([64.233.184.197:12129] helo=wproxy.gmail.com) by pb1.pair.com (ecelerity 2.0 beta r(6227M)) with SMTP id EF/18-61486-6616DD24 for ; Tue, 19 Jul 2005 16:24:06 -0400 Received: by wproxy.gmail.com with SMTP id 70so424755wra for ; Tue, 19 Jul 2005 13:24:04 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hKgzWjyBge779NR1u5eEVIZViJdF9WUVqAX4Vsu2nIvIBeiPGL6zPqHP14NOgATHs5djhmuOj6a43sI68eaArzXKkWdoDWxEZU1yRBbTORY0kSTNUwXdGRjlq+PhWw5flaPTyCKiKGoYz4yXA2KH7XeZ9VkD4IpPIyDl+1IP3LU= Received: by 10.54.38.54 with SMTP id l54mr869889wrl; Tue, 19 Jul 2005 13:23:10 -0700 (PDT) Received: by 10.54.153.5 with HTTP; Tue, 19 Jul 2005 13:23:10 -0700 (PDT) Message-ID: <4e89b426050719132323151018@mail.gmail.com> Date: Tue, 19 Jul 2005 16:23:10 -0400 Reply-To: Wez Furlong To: Andreas Ahlenstorf Cc: internals@lists.php.net In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: Subject: Re: [PHP-DEV] SQlite row size From: kingwez@gmail.com (Wez Furlong) Just because it is the library default; the intention is to make php generate sqlite files compatible with other applications that use sqlite. IIRC, you can happily exceed this "limit", it'll just be slower to access such a row. To be honest, support for blob style data in sqlite 2 and below is pretty crappy; if you're serious about it, I'd suggest upgrading to PHP 5.1 and using PDO SQLITE instead. SQLite 3 (which it uses) actually has a concept of binary data. --Wez. On 7/19/05, Andreas Ahlenstorf wrote: > Hi, >=20 > I'm playing around with SQlite in PHP 5 and as far as I can see, the > row size is limited to 1 MB, even it's possible to set it up to 16 > MB. What's the reason for it? I know I can change it for myself when > I recompile the extension, but that's quiet hard on Windows without a > compiler and without the required knowledge... >=20 > Andreas >=20 > -- > PHP Internals - PHP Runtime Development Mailing List > To unsubscribe, visit: http://www.php.net/unsub.php >=20 >