MySQL Forums
Forum List  »  Newbie

Re: Optimisch queries
Posted by: Rick James
Date: November 28, 2015 03:13PM

Faction seems to be numeric, yet you called it TEXT.

How many rows in `Bl_Chunks`?

"because it would be to much data" -- how much is "too much"? Thousands should be no problem. Millions might be ok.

In pow(2, $distance), do you care that $distance is usually not integral?

Add some instrumentation to find out how many times you are executing each SQL statement. The numbers may surprise you.

Does SqlGet() check for errors after execution? If not, be sure to catch errors.

Options: ReplyQuote


Subject
Written By
Posted
November 26, 2015 02:58PM
Re: Optimisch queries
November 28, 2015 03:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.