Search results for query: *

I currently have Trasaction Durability enabled. The system is correctly producing the .LOG files. The problem I am having is the log files is that the old log files are remaining on the system log after the application and the trasaction that created them has successfully completed. Right now I...

does anyone know of a good whitepaper on setting up and recovering a database with transaction log files.

What I am trying to do is asmiple database audit. Just showing the tables, views, indexes their column names , column sizes row lenghts... Stuff like that. I am just documenting the database without having to cut and past the DDL.

I am looking for a list of queries that query metadata information form a database ( Table size, Index names + base table, Size ( in Bytes) of rows stuff like that. There does not saeem to be allot written on the Pervasive database like Oracle or Sybase

now how do I add the number of bytes in a record and the number of rows in the table to the query

I read the documentation on the create table command. I can not see a way to create a table as a subest ( both columns and data) form another table. In ORACLE SQL this is done by a CREATE TABLE as Select Statement). My question is is there an equivilent statement in Pervasive? Example: tbl1 (...

You are correct 3 gigs is not very much data. but a simple "SELECT count(*) from Table_name" of a 270K row table can take up to 5 minutes to run. The table has 435 columns and some of the columns are varchar(65000). The DB is a thrid party product. So I can not redesign the it (The real...

How much data are you talking about? 3 gigs What exact version of PSQL are you using (v9.0, v9.1, v9.5)? V9.5 Are you using the Workgroup or Server engine? Server engine What are the hardware specs of the machine where the data / engine resides? 1.8ghz P III with 2 gigs of RAM How many...

The Version is 9 [b]I am using SQL interface. The OS is Windows XP. I am looking for documentation telling me what to look for where to look ( What internal Paramenters init parameter etc...) to tune the Pervasive processes. As there are no tools ( Like with Oracle, MS SQL, MYSQL) that will...

Does anyone know a good whitepaper on how to tune the Pervasive sql process ( Windows XP OS). I currently have a default sized server. given the amount of data that I am starting to process I know I have to expand the internal buffers. what I do not know is how or what to monitor to determin...

I need to write a query that will list table name and the number of columns in each table. example of results: table_name + # of COLs table_one | 20 table_two | 350 . . .