multi sql select then insert

Question

i have a total of 6 different tables that i select from then insert to a table before i do another select i was wondering if there was a way to skip the insert part and just do a select and combine all table data. the problem with the select and insert then select aproach is it gets really slow when there are about 1k+ records inserted. it takes about 30sec to 1min or more

im trying something like this

$sql = "select 1";
$statement = $conn->query($sql);
$rowset = $statement->fetchAll();

$sql1 = "select 2";
$statement1 = $conn->query($sql1);
$rowset1 = $statement1->fetchAll();

$combine = array_merge($rowset,$rowset1);


foreach ($combine as $key => $part) {
       $sort[$key] = strtotime($part['date']);
}
array_multisort($sort, SORT_DESC, $combine);

You need to give us way more details. What are you selecting? What are you inserting, how are you inserting and why? What does the db-schema look like? What are you actually trying to accomplish? — M. Eriksson
– M. Eriksson, Commented Oct 11, 2016 at 5:31

Shadow · Accepted Answer · 2016-10-11 05:33:09Z

3

To me it seems that you are replicating in php what you could do in sql. The above code in sql looks sg like this:

(select 1)
union all
(select 2)
order by date desc

You may have to tweak the order by clause depending on what data you exactly have in the date field. Otherwise, the above sql code should produce the exactly same results as your php code.

answered Oct 11, 2016 at 5:33

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

multi sql select then insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related