Search found 951 matches

by Einar Saukas
Mon Dec 30, 2019 1:36 pm
Forum: Website
Topic: Website issues
Replies: 8
Views: 550

Re: Website issues

I can suggest doing some steps for this: 1. You can enable file cache for zxImage library, this will save a lot of CPU resources. 2. Profiling SQL requests to find the slowest ones and setting up appropriate indexes would help a lot. 3. You can also set up some data-caching for the heaviest SQL req...
by Einar Saukas
Mon Dec 23, 2019 5:50 am
Forum: ZXDB Discussion
Topic: New Database Model ZXDB
Replies: 228
Views: 26469

Re: New Database Model ZXDB

Another ZXDB update is now available!

Merry Xmas!!!
by Einar Saukas
Sat Dec 07, 2019 4:23 pm
Forum: Brand new software!
Topic: 19 new games at Yandex competition!!!!
Replies: 73
Views: 3032

Re: 19 new games at Yandex competition!!!!

ZXDunny wrote:
Sat Dec 07, 2019 3:44 pm
g0blinish wrote:
Sat Dec 07, 2019 2:30 pm
ZXDunny wrote:
Sat Dec 07, 2019 2:17 pm


wuh?
if you walking up/down and want to turn right press twice uo and right.
What?
He means that, if you are moving down and wants to turn at the next right passage, then simply keep pressing both down and right keys.
by Einar Saukas
Sun Dec 01, 2019 8:28 pm
Forum: ZXDB Discussion
Topic: New Database Model ZXDB
Replies: 228
Views: 26469

Re: New Database Model ZXDB

Another ZXDB update is available!

As usual, it contains new titles (thanks @R-Tape!), new hires inlays and/or instructions (thanks @pavero!), and new fixes (thanks @druellan!).
by Einar Saukas
Mon Nov 25, 2019 9:04 pm
Forum: ZXDB Discussion
Topic: Little bugs in the database 2
Replies: 407
Views: 28982

Re: Little bugs in the database 2

Similarly, BMX Simulator 2 is the budget re-release of Professional BMX Simulator from CodeMasters Plus. This version has 10 circuits compared to the 15 on the double tape release. https://spectrumcomputing.co.uk/pub/sinclair/screens/in-game/p/ProfessionalBMXSimulator.gif https://spectrumcomputing....
by Einar Saukas
Mon Nov 25, 2019 2:20 pm
Forum: ZXDB Discussion
Topic: ZXDB and ZX-Art
Replies: 25
Views: 3620

Re: ZXDB and ZX-Art

Seems like releases.releases_seq has been changed after all? So my key strings based on entry_id + release_seq are now wrong and pointing to wrong releases? My apologies. Old WoS had quite a few cases of incorrectly ordered releases, such as a re-release #3 from 1984 and re-release #4 from 1983. Th...
by Einar Saukas
Fri Nov 22, 2019 1:34 pm
Forum: Website
Topic: Site Updates
Replies: 393
Views: 43105

Re: Site Updates

Try now :)
by Einar Saukas
Fri Nov 22, 2019 1:12 pm
Forum: Website
Topic: Site Updates
Replies: 393
Views: 43105

Re: Site Updates

Listing original titles before mods is probably a good idea.

For everything else, most users would probably be complaining that alphabetical sorting is broken.
by Einar Saukas
Wed Nov 20, 2019 6:56 pm
Forum: ZXDB Discussion
Topic: New Database Model ZXDB
Replies: 228
Views: 26469

Re: New Database Model ZXDB

A new ZXDB update is available!

Once again it contains new titles (thanks @R-Tape!), new hires inlays (thanks @pavero!), and new fixes (thanks @druellan!).
by Einar Saukas
Tue Nov 19, 2019 5:46 pm
Forum: ZXDB Discussion
Topic: SQL for dummies
Replies: 16
Views: 806

Re: SQL for dummies

Ops! My first attempt had a bug that duplicated some data. Here's my second attempt: CREATE VIEW z_products AS SELECT e.id, e.title, e.library_title, e.is_xrated, e.is_crap, mt.text AS machinetype, e.max_players, gt.text AS genretype, st.text AS spot_genretype, pt.text AS publicationtype, vt.text AS...