Consider the following queries:

select field1, field2 from Product where ProductID = 1;

update User set Firstname = 'jim' where UserID = 3;

MySQL will update the row that matches the ID, but also search the index or perform a table scan to find more matching rows in the table.

A simple limit on queries that will only ever select, update or delete one row can save some valuable execution time when your database grows.

select field1, field2 from Product where ProductID = 1 limit 1;

update User set Firstname = 'jim' where UserID = 3 limit 1;

I did manage to breach 100BPM on the scales to 105. I could play uncleanly to around 115 for diatonic scales and 135 on the chromatic scales!

Here’s my improvement over this last week, first figure start of week and the last figure the end of the week. All tempos are playing semi-quavers.

Diatonic scales and modes, Ionian to Ionian
100bpm / 105bpm

Chromatic exercises
100bpm / 105bpm

Alternating string arpeggios (1, 3, 2, 4, 3, 5, 4, 6, 6, 4, 5, 3, 4, 2, 3, 1)
75bpm / 80bpm

Non-scalar string skipping alternate picking (1, 3, 4, 6, 6, 4, 3, 1)
75bpm / 75bpm

Arpeggio sweep picking exercises
70bpm / 70bpm

Here’s my improvement over this last week, first figure start of week and the last figure the end of the week. All tempos are playing semi-quavers.

Diatonic scales and modes, Ionian to Ionian
100bpm / 100bpm

Chromatic exercises
100bpm / 100bpm

Alternating string arpeggios (1, 3, 2, 4, 3, 5, 4, 6, 6, 4, 5, 3, 4, 2, 3, 1)
70bpm / 75bpm

Non-scalar string skipping alternate picking (1, 3, 4, 6, 6, 4, 3, 1)
65bpm / 75bpm

Arpeggio sweep picking exercises
65bpm / 70bpm

This marks close to one month and it has really paid off. I am much more accurate and faster. I have also found myself writing better solos as well. If this trend continues, it will be six months until I reach goal number one of 130bpm.

Here’s my improvement over this last week, first figure start of week and the last figure the end of the week. All tempos are playing semi-quavers.

Diatonic scales and modes, Ionian to Ionian
100bpm / 100bpm

Chromatic exercises
100bpm / 100bpm

Alternating string arpeggios (1, 3, 2, 4, 3, 5, 4, 6, 6, 4, 5, 3, 4, 2, 3, 1)
65bpm / 70bpm

Non-scalar string skipping alternate picking (1, 3, 4, 6, 6, 4, 3, 1)
65bpm / 65bpm

Arpeggio sweep picking exercises (new)
40bpm / 65bpm

Here’s my improvement over this last week, first figure start of week and the last figure the end of the week. All tempos are playing semi-quavers.

Diatonic scales and modes, Ionian to Ionian
100bpm / 100bpm (better at 105 than last week, but still messy)

Chromatic exercises
100bpm / 100bpm

Alternating string arpeggios (1, 3, 2, 4, 3, 5, 4, 6, 6, 4, 5, 3, 4, 2, 3, 1)
70bpm / 65bpm

Non-scalar string skipping alternate picking (1, 3, 4, 6, 6, 4, 3, 1)
70bpm / 65bpm

Non-scalar sweep picking exercises
70bpm / 65bpm

$sql = "delimiter $$

drop procedure if exists spsTableDelete $$
create procedure spsTableDelete(mySession nvarchar(255),myTableID bigint unsigned)
begin

		update sTable
		set Deleted = TableID
		where TableID = myTableID;

end $$

delimiter ;";
$this->mysqli->multi_query($sql);
if (strlen($this->mysqli->error) > 0)
	echo "<p class='error'>".$this->mysqli->error."</p>";
else
	echo "$operation Procs Written<br />\n";

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘delimiter $$’ at line 1

The problems is that MySQLi does not use delimiters so the following code will work instead:

$sql = "drop procedure if exists spsTableDelete ;
create procedure spsTableDelete(mySession nvarchar(255),myTableID bigint unsigned)
begin

		update sTable
		set Deleted = TableID
		where TableID = myTableID;

end ;";

$this->mysqli->multi_query($sql);
if (strlen($this->mysqli->error) > 0)
	echo "<p class='error'>".$this->mysqli->error."</p>";
else
	echo "$operation Procs Written<br />\n";

I have two targets.
1. 130bpm semi-quavers in diatonic scales
then
2. 160bpm semi-quavers in diatonic scales.

The first figure is so that I can cleanly play the solo I wrote, and the second is just an arbitrary figure that would make me feel like a shredder.

Here’s my improvement over this last week, first figure start of week and the last figure the end of the week. All tempos are playing semi-quavers.

Diatonic scales and modes, Ionian to Ionian
80bpm / 100bpm

Chromatic exercises
90bpm / 100bpm

Alternating string arpeggios (1, 3, 2, 4, 3, 5, 4, 6, 6, 4, 5, 3, 4, 2, 3, 1)
55bpm / 70bpm

Non-scalar string skipping alternate picking (1, 3, 4, 6, 6, 4, 3, 1)
?? / 70bpm

Non-scalar sweep picking exercises
?? / 70bpm

I didn’t take a close note of the speeds at the beginning of this week, so there are some holes in data. I can play up to around 140bpm for the chromatic exercises, but it is pretty messy. All figures are for relatively clean playing.

A lot of the improvement this week would have been getting back to my old speed, so I think each week from now will have less increases.

http://tools.thewebsiteguy.com.au/password.php