Ok, great.
I am wondering if there is a way to execute an SQL command through some
FB utiltity from a shell. Smth like:
bash> time isql -c "SELECT count(*) FROM tableA" /tmp/mydb.fdb

Another question is what is the aliases.conf file for in the firebase
directory. I set it to point to my database file:
mydb=/tmp/mydb.fdb
But wher I run:
bash> isql mydb
It doesn't find the database file.

Thanks for your help.


-----Original Message-----
From: Milan Babuskov [mailto:albis@...]
Sent: Tuesday, September 30, 2003 11:40 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Import data from flat files
Importance: Low


Oleg Lebedev wrote:

> Inserting 1,500,000 rows took 30mins., which is not so bad.
> I have another table, which contains 6,000,000 rows, so I guess I will

> be having a long lunch today :)

:)

> I am not sure if I have my write-back cache enabled or not. I will
> make sure to disable it before I do the next insert.

Snice you're controlling the process you can enable it, i.e. set the
forced writes off. It's good to turn it on in production environment, so

that power failure doesn't corrupt the database.

> Is there a way to find out whether the async write is enabled or
> disabled?

Are are many ways, for example you can connect to database with isql,
and issue "SHOW DATABASE" command. Watch for "Forced Writes" line.

--
Milan Babuskov
http://fbexport.sourceforge.net




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

*************************************

This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.

*************************************