Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: FBELGHAIT
  • Content: Threads
  • Order by date
  1. FBELGHAIT

    Crystal report & Temporary table

    Hi, I want to create a report that will use a temporary table in vb6 with "create temp table as select ....". is it possible? i use postgres as dbms thanks for your help fodil
  2. FBELGHAIT

    Views and parameter

    Hi, From the clients, i need to run the same view but with different parameter in order to generates reports with crystal (Chrystal report uses the view ). is it possible? if yes show me how please. thanks a lot.
  3. FBELGHAIT

    postgres odbc slow. need help

    Hi, i have a query that returns about 6000 records. when i do EXPLAIN ANALYZE, the time estimated is 1500 ms. When i try to fill a recordset with ADO it tooks more than 35 second !!. is it problem of odbc? thanks for your help fodil
  4. FBELGHAIT

    PostGres and Space Disk

    Hi, I have a database on postgres server, i noticed that i lose space disk just by trying select queries, and when i use VACUUM command, it takes a lot space. i wander if it uses a temporary files without deleting them when the action is finished. if yes, tell me please the name and the place...
  5. FBELGHAIT

    Postgres ODBC very slow

    Hi every body, I have postgresql version 7.1.3 installed on AIX OS, and an ODBC version 7.1.9. I tried to execute simple sql query on my PC using the odbc, and it was very slow. the same query on the AIX machine is very quick. i don't know if there is something to do in order to make...
  6. FBELGHAIT

    How to Call a stored function with ADO

    Hi, I have a stored function created in a postgres database, that function returns an integer value and i want to run that function from VB using ADO. I used with vcmd .CommandType = adCmdStoredProc .CommandText = "fn_insertdata" 'fn_insertdata is the...
  7. FBELGHAIT

    Postgres versy slow, more details

    Hi, i've postgres version 7.1.3 and is runing on AIX, the ODBC driver i'm using is version 7.1.9. In my table there is 44 fields all of them are of type VARCHAR,FLOAT8,DATESTAMP. also i have 3 indexes and one primary key. i'm using windows 95. and i'm using pgadminII to open the database...
  8. FBELGHAIT

    Queries on Postgresql very slow!

    Hi, I have a large table that i imported from MsAccess, i tried a simple query on MsAccess and on Postgresql, and i noticed that postgres is very slow to load the table, and some times he loose the connection to the database completly The query is like : select * from table, my table is...
  9. FBELGHAIT

    Postgresql doesn't accept DISTINCTROW

    Hi every body, I need to use DISTINCTROW in my sql statement, but the parser of postgres doesn't accept it. the following sql statement doesn't work on postgres SELECT DISTINCTROW field1,field2 FROM TABLE when i replace "distinctrow" with "distinct" it works. if...

Part and Inventory Search

Back
Top