Skip to Content.
Sympa Menu

freetds - Re: [freetds] Memory Overflow on apache using freetds and php

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Frank M. Kromann" <frank AT kromann.info>
  • To: lbayuk AT mindspring.com, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Memory Overflow on apache using freetds and php
  • Date: Sat, 31 May 2003 07:03:59 -0700

Hi,

The native MSSQL extension supports a slightly different method for this.
You can specify the Batch size before quearying the database and use
mssql_fetch_batch() to fetch each batch.

This method reduces the network overhead you would get by fetching one row
at the time from the server.

- Frank

> Aliet Santiesteban Sifontes wrote:
> >
> > The tables have 42539 records, and ASSNS_Almacen has
> > 61 records, I'm doing the query to return all of
> > them...
>
> For really large result sets, you may want to try using an unbuffered
query
> call, which avoids storing the entire query result in memory. (This
assumes
> you are processing result rows in order.)
>
> PHP 4.3.0 added sybase_unbuffered_query() to the sybase_ct extension,
to
> solve the memory usage problem, and also the latency problem (normally
the
> first row won't be available to your script until the entire result set
> is returned). Unfortunately, this is poorly documented and I don't know
> if it really works. The latest manual mentions but does not show the
3rd
> parameter to the call: sybase_unbuffered_query($query, $link_id,
$store);
> If $store is FALSE, the query result won't be stored in memory. At
least
> that's how it should work. If you can try it, tell us if it works.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>






  • Re: [freetds] Memory Overflow on apache using freetds and php, Frank M. Kromann, 05/31/2003

Archive powered by MHonArc 2.6.24.

Top of Page