APM: Last question (for today)

[Mark Lehmann]

Use your databases limit feature.  Often the word "LIMIT" followed by a
number at the end of the statement.

example:

SELECT *
  FROM dual
 LIMIT 1;

-- 
Mark Lehmann

On Tue, October 24, 2006 15:53, CaptNemo wrote:
> Okay, I have got everything working the database queries ok and returns
> data (into a variable)-
>
> $dbdata = `bdquery.pl`;
>
> Now, I'm worried about someone doing a wildcard query on our table with
> over 200K entries and overflowing something.  Is there a way to limit
> variable size in perl?
>
>
>
> IF SO,
> What would be a reasonable upper limit (keeping in mind that some queries
> may be a large but necessary)?
>
> _______________________________________________
> Austin mailing list
> Austin at pm.org
> http://mail.pm.org/mailman/listinfo/austin
>