101 reputation
bio website bookmeme.net
location London, United Kingdom
age
visits member for 1 year, 10 months
seen Aug 18 at 11:37

Software Developer at Crowdsurge in London.

Experienced in OO PHP, Zend Framework development. Javascript 'pure' and using jQuery (mostly). Relational Db: SQL Server, mySql. NoSql using CouchDB and MongoDb.

Agile/Scrum approach.

Previous experience includes system admin for a disability charity in West London and Web developer at Mediatel Group Ltd in London.


Dec
24
comment SQLite UPDATE two tables from VIEW or TEMPORARY TABLE
You can't store data in a view, it is a way of storing a query to get a 'VIEW' of the data you are interested in. A temporary table is just that, a table, thus you can run all the table operations against it. I recommend making heavy use of the MySql online documentation and trying out a few things yourself. See this SO question for how to do an INSERT..SELECT stackoverflow.com/questions/5391344/insert-with-select
Dec
23
comment MySQL Queries taking too long to execute
You should check for over-indexing in this situation and as you are sharing the server with the apache you might be running into resource issues if there is any load to speak of. Adding the information suggested by @Michael-sqlbot is a very good starting point.
Dec
23
comment SQLite UPDATE two tables from VIEW or TEMPORARY TABLE
Have you tried prototyping the query in smaller sections instead of creating one big blob. Additionally have you tried creating a temporary table instead of a temporary view in your second example.