Currently viewing the tag: "Best"
Question: What is the best practice for coding a php/mysql event calendar with recurring events?
We are debating using ICS files, mysql tables, a combination of both – just not sure what the most scalable method will be. In the system, calendars will be shared between users, and users will have the ability to export ICS files to import on their local computers.
Answer:
Answer by Squirrelly
I would say ICS files are great for a standard importing and exporting of data, but you’ll want to definitely store the “live” data your application runs on in some sort of database for it to be both efficient and scalable. Constantly parsing plain text files without any sort of indexing will not be very efficient.
Once you have the data in a db, creating an ICS file for export should be easy when the user requests one.
Question: What is the best approach to delete garbage and expired entries in a MySQL database?
I want to delete users that hasn’t logged in in a certain amount of days, and other expired entries in a database. What is the best way of doing this automatically? I’m using MySQL and PHP for my web application.
One way I have thought is having a clean_db() function that I call in every page request. Other option can be programming a cron script that runs automatically at certain times.
What is the best way of cleaning a database?
Answer:
Answer by Pieter v L.
I’d go for a cronjob.
If you have many visitors, the amount of SQL connections might slow down your server.
Clean outdated records every page someone visits, is way to inefficient, unless you have hunderds of records expiring every hour.
As I guess this is not the case, I advise you to it with a cronjob.
You have to ask yourself: Is every page an extra SQL connection to check for expired records more effective then having a little bit garbage in your database for a couple of hours, as databases are made for storing loads of information.
Question: What is the best procedure to move MySQL data from one disk to another?
I have a server that I want to run purely for the database, now the mysql is installed on one hard drive, I want to move it to another hard drive and still be compatible with webmin, how would i go about doing this?
Answer:
Answer by Jim
1. Take a backup
2. delete the current database.
3. allocate a new database.
4. restore the backup from 1.
enjoy
free web hosting at www.000webhost.com PHP, MySQL, phpMyAdmin, CGI, Curl, cPanel Perl and much, much more! Pages Load FAST cPanel easy to use. Integrated into login. This free website hosting is at www.000webhost.com Quick note: the subdomain you can get with this free hosting offer are rotated every once in a while. Easy to fix with bit.ly auto installer that will allow you to install many premade scripts you can put on your hosted site very easily — hosting is all completely free. Free hosting at www.000webhost.com Also, there are NO FORCED ADS – ever with this hosting! Hosting is available at www.000webhost.com Install a BLOG! – WordPress, b2evolution, Nucleus, and more, all for free! Install a FORUM! – Install phpBB for free, or SMF (or others!) You can sign up for this FREE web hosting offer, completely free at www.000webhost.com Unlimited Sub-Domains! – all working all the time! AGAIN, FREE!! They aren’t ever going to charge for this free website hosting! Once again, you can get this free web hosting at www.000webhost.com I’m going to be straight forward with you. www.000webhost.com is my affiliate link. I earn a few dollars for each signup. But that doesn’t come out of what you pay – you don’t pay anything! This is all free! I can’t stretch the fact that it’s all free any more! If you sign up using www.000webhost.com it’s a very nice way of saying “Thank you for introducing me to my great new, FREE hosting!” I would be so grateful if you would sign up through me …
Kevin Yank demonstrates how to install PHP & MySQL server software on Mac OS X using MAMP in day 1 of PHP Live. For more information, visit www.sitepoint.com
Learn best practices for securing your PHP and MySQL websites and applications. Here are the resources: php.net developer.yahoo.com www.phpfreaks.com phpsec.org
Question: hi frnds, which book is the best for pl sql “brush up” learning with “interview” point of view?
how about oracle press book,
http://www.amazon.com/exec/obidos/ASIN/0072261943/oraclefaq
Answer:
Answer by Rawlyn
Define “best”.
To prepare for an interview, the best you can do is brush up on what you already know. At the end of the day, information that you can remember on the day of the interview, but not on your first day of work, is of no use to you or your employer…
Tune in as EMC’s Chad Sakac, senior practice manager for databases and messaging, discusses the challenges of deploying a large database environment. Chad outlines the features and functionalities of SQL Server 2005 and how they were used for Project REAL—a reference architecture built jointly by Microsoft and EMC. For More Information Visit EMC: www.emc.com