Performance degradation when using sqlite 3.3.5 program against sqlite 3.2.1 db-files
The database version does not impact performance much.You can verify this yourself by converting your database files tothe 3.3.5 format.I'm guessing that you are seeing a difference in query performancebetween 3.2.1 and 3.3.5. Much code has changed between these twoversions, including the a...
0 answers | 1801 bytes |
threading vs no threading compilation performance
For a single-threaded application, is there some performance benefit tocompiling SQLite3 with the THREADSAFE=0 option? The only thing I do in amulti-threaded situation is inserts, and I'm wondering if I'm not better offjust multiplexing them myself so that I only have to worry about on...
0 answers | 386 bytes |
SQLite without callback function
Have not you forgot the bind ?Mario HebertLegerityJohn Stanton <johns (AT) viacognis (DOT) com05/30/2006 04:55 PMPlease respond tosqlite-users (AT) sqlite (DOT) orgTosqlite-users (AT) sqlite (DOT) orgccSubjectRe: [sqlite] SQLite without callback functionUse sqlite3_prepare, sqlite3_step, sqli...
1 answers | 811 bytes |
Application errors from upgrading sqlite2-8.13 to sqlite-3.3.5
I am using tcl8.4.6 and have upgraded my sqlite from sqlite-2.8-13 tosqlite-3.3.5. I originally tried to update my tcl8.4.6 to tcl8.4.11 andcould not get my application to run. I can get my application to comeup with tcl8.4.6 and the sqlite-3.3.5 with some problems. Afterchanging application cal...
1 answers | 941 bytes |
SCSI disk: still the way to go?
Hi guys, I have to update a Linux box with PostgreSQL on it, essentially for datawarehousing purposes. I had set it up about 3 years ago and at that time thebest solution I had been recommended was to use SCSI disks with hardwareRAID controllers. Is this still the way to go or things have recent...
14 answers | 437 bytes |
Problem V8.1.4 - providing pwd for commandline tools doesn't workanymore
The latest version (V8.1.4) breaks the setup process of ourapplication's installation wizard. We used to call "createdb.exe" andpiped the password for the postgres user (which has been entered by theuser in our setup wizard's dialogs) into it.With version V8.1.4 this is not possible an...
0 answers | 1118 bytes |
out parameter and setof record
In PostgreSql 8.1 i've tried to use parameter but when I've changedfunction (added parameter)CREATE R REPLACE FUNCTIN reffunc3(FRM_ID in integer,****_RW UTinteger) RETURNS SETF Person AS 'DECLARE rec RECRD;BEGIN SELECT count(*) INT ****_RW FRM Person WHERE ssn>FRM_ID ; FR rec I...
1 answers | 878 bytes |
Restoring databases from a different installment on Windows
I have recently reinstalled my Windows mychine, including thePostgreSQL server, but (due to a system crash, unrelated to Postgres) Iwasn't able to dump my databases to import them now. However, I have afull copy of the original system, including all the files of theoriginal Postgres install...
4 answers | 804 bytes |
Problem in pgsql
Dear sir,I am encountering these errors-bash-2.05b$ createuser -U postgres -d -A -P dspaceEnter password for new role:Enter it again:Shall the new role be allowed to create more newroles? (y/n) ncreateuser: relocation error: /usr/lib/libpq.so.4:undefined symbol: krb5_cc_get_principal-bash-2.05b$...
0 answers | 1474 bytes |
Error linking initdb
Hello,I'm building postgresQL on Sparc10 and get following error. Did anybodysee this error before and can suggest me a way to fix it?Thank you all./usr/local/bin/gcc -Wall -Wmissing-prototypes -Wpointer-arith-Winline -Wendif-labels -fno-strict-aliasing initdb.o-L///src/port -lpgport -lpq-L...
0 answers | 1050 bytes |
Schema authorization proplems
I'm trying to use schema and roles but I'm not having much success(using PostgreSQL Database Server 8.1.2).I want to set up a test area in the database using the schema "storage"in the database "test".There are 2 groups "storageadmin" and "storageuser"."storageadmin" members should be...
0 answers | 2040 bytes |
the problem plz solve
i install the postgresql with service and create data base after that i uninstall it and install without service when i run it with pg_ctl its work fine but when i copy structure of 8.1 folder and overwrite it on other m/c or install postgresql folder and try to run the pg_ctl command then it gi...
1 answers | 756 bytes |
- Performance degradation when using sqlite 3.3.5 program against sqlite 3.2.1 db-files
- threading vs no threading compilation performance
- SQLite without callback function
- Application errors from upgrading sqlite2-8.13 to sqlite-3.3.5
- Problem V8.1.4 - providing pwd for commandline tools doesn't workanymore
- out parameter and setof record
- Restoring databases from a different installment on Windows
- Problem in pgsql
- SCSI disk: still the way to go?
- Purging the mailing list roles. Was: Please RestoreYourAccount Access
- Lossy character conversion to Latin-1
- Charset conversion error
- National Number to text conversion
- Purging the mailing list roles. Was: Please RestoreYour Account Access
- LIMIT and paging records
- Please Restore Your Account Access
- Home- About Us- Contact- Privacy Statement- Link Exchange- Bookmark- Map.XML- Rss.Xml
- Copyright 2001-2008 by EMSDN.COM Information Technology Co.,Ltd All rights reserved
- 0.781