>> I have a soda tank inventory tracking app (PySlang-based >> text UI :-D) using Firebird 1.0 (the first release) and >> running on Slackware 8.1. It's been in extensive use >> for quite some time and we haven't experienced any >> locking issues. I'm pretty sure we've hit 2000 SELECTs >> by now. > > >ok., =) > >but can you try some test like the ff pseudocode >on a 10,000 row x 1,000 column table: > >i = 1 to 10000 > select * from table where id=i >next i > ....
(more) problems that i've encountered on firebird (afaic)
- no LIMIT predicate (but there's a workaround) - some basic ODBC calls aren't working such as row counts. (but then again, there's a workaround). - session locking(?): 2 clients updating the database but they can't see the updates made by the other client unless they reconnect to the server. (useful but not what i needed). any workaround? tips?
-- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
