> On Apr 14, 2017, at 1:07 PM, shawn l.green wrote:
>
> That all depends. Do you...
Hi Shawn,
I thought I had replied to your response, but it looks like I didn’t.
Thank you for your email. It was a thorough response and the links were very
helpful, as well. I’ve settled on both DA
I have creation date/time fields in my script that are formatted as
|MM|DD|hh|mm|ss. Short of changing the script, should I set the field type
in MySQL to DATETIME, or would it be better in terms of speed and efficiency to
set it as char(19)? Or would it not make a difference?
Tha
> On Apr 12, 2017, at 3:38 PM, Ronan McGlue wrote:
>
> Enable the slow log on the DB.
Thanks Ronan. That sounds like it would be beneficial. I take it
you’re referring to a setting on the server, though. If that’s the case, I
don’t think I can do that as I’m on shared hosting (unles
> On Apr 11, 2017, at 1:26 PM, Michael Munger
> wrote:
>
> Use MySQL workbench.
Thanks, Michael. I played with it some already and it looks like it
will give me a lot to work with.
Will it also let me know if field types are wrong for the given
information type, or is that a
Is there a way, perhaps with a script or a service, that one can check
MySQL code to see about making it more efficient? I maintain an open source
shopping cart written in Perl and it’s been awhile since the SQL has been
worked on, so I want to see if it could use some updating.
Thanks
