considering that there is 72k items and each item has over 100 field entries, you asking the Db to pull out basically 7.2 million individual entries, and unless you have A LOT of free RAM the whole thing may very well crash
best to to view items either just pull 1k at a time, or limit the field you want to see
for example:
SELECT id, name, price FROM items where id>2000 and id<3000;
only shows you 3 properties and only for items in range of IDs from 2k to 3k
another thing- download official mySQl query browser from official site. Its awesome =)
|