Re: SQL or array ?
| From: | M Saleh EG | Date: | Sun, 24 Apr 2005 03:08:40 +0000 |
| Subject: | Re: SQL or array ? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39262@lists.php.net to get a copy of this message | ||
Only? That aint too big, but now i'm confused what's ur hardware and
O.Sspecs? 300 to 500 would be a peice of cake to load. However, it
depends on
ur system.
I would rather use the array than hitting the db for the query. Because the
bottom line is that you will receive your data in an array no matter what
even if its in the db so doesnt realy matter unless you wanna paginate it.
In that case I'd use the db rather to array alone.
Wow Hold on. That's a catch 22. If ur loading ur array in the beginning of
the execution then just do it on the DB once n just load it the next time.
That means the next time you dont have to take a trip to ur file system n
then another trip to display the array. And plus if u needed to paginate
which of corse ull need to for such a number db helps, however paginating
arrays is easy as well.
HTH
Benchmark it! And find out for yourself.
On 4/24/05, Paul Reilly <pareilly@tcd.ie> wrote:
>
>
> > explain the phrase "big array."
>
> I guess everything is relative!
> We're talking about 300-500 items here.
>
> Paul
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
M.Saleh.E.G
97150-4779817