I\'m looking for som testing programs for a firebird db server, to stress-test and find bottlenecks. Something like DB-Optimizer, only for firebird would be nice开发者_Python百科.
Suppose a table with two columns: From and To. Example: From To 12 23 24 45 I would like to know the most effective way to locate all nodes that are reachable from a node using a SQL Query. Example
The query is: SET TERM ^ ; ALTER PROCEDURE SALVARROTA ( datahora timestamp, distancia double precision, custo double precision,
I have a production database, using Firebird 2.1, where I need to find out how much space is used by each table, including the blobs. The blob-part is the tricky one, because it is not covered using t
Using Firebird: I want to select a random entry in the table if the first SQL query returns 0 rows. Is there开发者_开发问答 anyway to combine these two queries?
I have converted a database from MySQL to Firebird, all tables name and field name are in lowercase, when I query the database, it gives me an error of table not found, because Firebird automatically
For debug purposes I need to send 1 table of an existing Firebird 1.5 database to someone. In stead of sending the whole db , I want to send just the db with just this table - no triggers, no constra
it is possible to get only one row per record in a multitable query? I have this three tables: APPLES ID | APPLE
I need some help with a query - I\'m using Firebird 2.1. I have a table like: RowID (primary key) | ActivityID | Duration | BilledAt
I am getting to know the dbexpress firebird driver from Chau Chee-Yang (http://sites.google.com/site/dbxfirebird/)
加载中,请稍侯......