On Wed, 2011-02-09 at 13:27 +0200, Arno Kuhl wrote:
> Instead of serializing the articles, you only need their IDs. Using
>
> $sql .= ' where id in (' . implode(',', $ids) . ')';
>
> you can load the data for a page of results in a single query. Storing the
> IDs is much cheaper than the art
Instead of serializing the articles, you only need their IDs. Using
$sql .= ' where id in (' . implode(',', $ids) . ')';
you can load the data for a page of results in a single query. Storing the
IDs is much cheaper than the articles.
If the permissions are fairly static (i.e. access for use
On Wed, 2011-02-09 at 13:03 +0200, Arno Kuhl wrote:
> On Tue, 2011-02-08 at 14:36 +0200, Arno Kuhl wrote:
>
> I'm hoping some clever php gurus have been here before and are
> willing to
> share some ideas.
>
> I have a site where articles are assigned to categories in
>
On Tue, 2011-02-08 at 14:36 +0200, Arno Kuhl wrote:
I'm hoping some clever php gurus have been here before and are
willing to
share some ideas.
I have a site where articles are assigned to categories in
containers. An
article can be assigned to only one c
On Tue, Feb 8, 2011 at 4:36 AM, Arno Kuhl wrote:
> But it might be an option if done once at the start of each
> search or list request, and then use that temporary modified result set for
> subsequent requests on the same set.
Instead of serializing the articles, you only need their IDs. Using
On Tue, Feb 8, 2011 at 1:36 PM, Arno Kuhl wrote:
> I'm hoping some clever php gurus have been here before and are willing to
> share some ideas.
>
> I have a site where articles are assigned to categories in containers. An
> article can be assigned to only one category per container, but one or m
On Tue, 2011-02-08 at 14:36 +0200, Arno Kuhl wrote:
> I'm hoping some clever php gurus have been here before and are willing to
> share some ideas.
>
> I have a site where articles are assigned to categories in containers. An
> article can be assigned to only one category per container, but one
On Tue, Feb 8, 2011 at 7:36 AM, Arno Kuhl wrote:
> I'm hoping some clever php gurus have been here before and are willing to
> share some ideas.
>
> I have a site where articles are assigned to categories in containers. An
> article can be assigned to only one category per container, but one or mo
I'm hoping some clever php gurus have been here before and are willing to
share some ideas.
I have a site where articles are assigned to categories in containers. An
article can be assigned to only one category per container, but one or more
containers. Access permissions can be set per article,
9 matches
Mail list logo