All Questions
Tagged with php optimization
14 questions
0
votes
0
answers
129
views
Improving/ Optimizing Performance Query in MySQL PHP
I have a invoices, invoices_items, order, order_items. Invoices and Orders tables contains around 1 Millions records. Invoices_items and Orders_items tables contains more than 2 Millions records. ...
- 1
0
votes
1
answer
1k
views
mysql index on varchar and date field for improve query speed of select and insert query
CREATE TABLE IF NOT EXISTS `gsm_smslog220717`
(
`pdsid` int(11) NOT NULL auto_increment,
`affiliateid` varchar(20) character set latin1 default NULL,
`bpushno` longtext character set ...
1
vote
1
answer
274
views
How to speed up mysql query using cache
I'm using the following query to create a leaderboard of top 10 people in this week.
SELECT
users.id,
concat(users.first_name, ' ', users.last_name) as name,
users.picture_url,
MAX(rounds.speed) ...
- 111
1
vote
2
answers
233
views
Efficient workflow/queries to save unique information?
I am saving company information in a database. There is a single table with an auto-incrementing key that is unique to each company. There are separate tables for emails, websites, phone numbers, and ...
- 91
0
votes
1
answer
117
views
Php, MySql - Optimisation
I asked this on the general site, but they suggested I come here for ultimate optimisation. It really boils down to which is faster; doing a load of calculations in php with database stuff that is ...
- 211
4
votes
2
answers
4k
views
SELECT and UPDATE in a single query while updating selective fields of duplicate records only
I have a MySQL table named Contacts_table with, say, the following contents:
ID NUMBER NAME CITY
001 2222222222 John Doe Los Angeles
002 ...
- 143
0
votes
1
answer
324
views
Storing small array of many possibilities
Let's say I need to store the text of a series of books, line per line in a database, and present them in a (CMS-based) website. I thought the correct setup would be:
a 'library' table: containing the ...
- 103
2
votes
1
answer
2k
views
MongoDB performance problem
I have a MongoDB for storing result like this
{_id, type, imei, lat, lng, spd, dir, time}
{_id, type, imei, lac, cid, time}
If type is f first one is used and if it is l second one is used.
Here is ...
- 167
0
votes
0
answers
169
views
Should I separate my preferences table?
I have a hobby site where users can find other hobbyists of similar interest. Each user can set a series of preferences that get saved into user_prefs. Right now there are 4 types of preferences, an ...
- 121
3
votes
1
answer
460
views
Mysql Fragmentation. How bad is too bad?
I ran a table status for my companies production site and its showing close to around '49085939712' for just about every table in my database and we have around 400 tables.
I am not a DB ...
- 133
0
votes
1
answer
423
views
Memcache implementation
I have a Wordpress site that uses WP Super Cache plugin in order to make my blog posts and pages stay as HTML so that less PHP/MySQL code is executed. However, there's a featured box that can't get ...
- 267
4
votes
1
answer
3k
views
Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
I have 3 simple tables with polls, users and votes. I'd like to show all polls ordered by clean count of votes (sometimes either poll_id or user_id don't get inserted).
Furthermore I'd like to show ...
- 53
2
votes
1
answer
1k
views
How to speed up mysql query?
I have query :
SELECT
`school`.`ARCO_name`,
`student-`.`ClassSize_7`,
`student-`.`ClassSize_8`,
`degree_o`.`degree_code`,
`accredit`.`full_faculty_3`,
`accredit`.`...
Wolf87
2
votes
1
answer
2k
views
SQL query optimization in Prestashop e-Commerce solution
I'm working on a layered navigation module within Prestashop e-Commerce solution.
I'm trying to optimize a SQL query which creates a temp table during execution. I think this is creating a ...
