Re: Is this a good idea?
- From: Jerry Stuckle <jstucklex@xxxxxxxxxxxxx>
- Date: Wed, 18 Jan 2006 07:26:11 -0500
R. Rajesh Jeba Anbiah wrote:
sam.s.kong@xxxxxxxxx wrote:
Hi!
I've been programming ASP for 5 years and am now learning PHP. In ASP, you can use GetRows function which returns 2 by 2 array of Recordset. Actually, it's a recommended way in ASP when you access DB as it disconnects the DB earlier. Also, it's handy as you can directly access any data in the array without looping.
<snip>
As many people have pointed out, *never* dump the table data into array. Fetch the record and immediately get that processed. If you have any *valid* reason, buffer the data into a very very small (known) sized array. If using MySQL, use the LIMIT if possible.
-- <?php echo 'Just another PHP saint'; ?> Email: rrjanbiah-at-Y!com Blog: http://rajeshanbiah.blogspot.com/
And it's *never* a good idea to give absolutes :-).
There are times when it's better to dump a table into an array - like when you have a lot of processing to do on multiple items and want to release mysql resources.
Also collection classes for abstracting the data. And that's just the beginning.
-- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@xxxxxxxxxxxxx ================== .
- Follow-Ups:
- Re: Is this a good idea?
- From: Iván Sánchez Ortega
- Re: Is this a good idea?
- References:
- Is this a good idea?
- From: sam . s . kong
- Re: Is this a good idea?
- From: R. Rajesh Jeba Anbiah
- Is this a good idea?
- Prev by Date: Setting Interbase dialect to 3 using ADODB Ver 4.70.
- Next by Date: Re: four or five shopping cart design questions
- Previous by thread: Re: Is this a good idea?
- Next by thread: Re: Is this a good idea?
- Index(es):
Relevant Pages
|