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!

  • Congratulations SkipVought 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: *

  1. SurgeX

    PSQL is terribly slow. MSSQL - 10 sec, PSQL - 5 min!!!

    No, not really. We've decided not to port our app to PSQL.
  2. SurgeX

    The account is not authorized to log in from this station

    Hi Guys, --- \\PCNAME is not accessible. The account is not authorized to log in from this station. --- That's the message I get when I try to access any PC in the domain from a W2K server. The server is running Citrix and I suspect it was somehow secured to restrict users from mapping back...
  3. SurgeX

    PSQL is terribly slow. MSSQL - 10 sec, PSQL - 5 min!!!

    Thanks Mirtheil, you helped a lot. We'll continue our tests and then decide whether we go with P.SQL or not...
  4. SurgeX

    PSQL is terribly slow. MSSQL - 10 sec, PSQL - 5 min!!!

    Yes, that's better, thank you. At least I'm getting comparable results now. The problem was that the programmer was using the Jet interface or something... But anyways. Simple queries are OK, but ones with multiple joins keep P.SQL busy for hours and seem never complete. I suspect it has...
  5. SurgeX

    PSQL is terribly slow. MSSQL - 10 sec, PSQL - 5 min!!!

    First we just ran the query from within P.SQL Control Center, in the SQL Data Manager (BTW, it's P.SQL 2000i SP4) and then we thought OK, fine, maybe it's just the way this "Query Analyzer" works. Then we wrote (I say 'we' cuz it was a programmer and me, I'm kinda managing this eval...
  6. SurgeX

    PSQL is terribly slow. MSSQL - 10 sec, PSQL - 5 min!!!

    Hi All, We're looking at porting our app to PSQL. We got a table with 40,000 records in it and a simple query like "SELECT * FROM TABLE" runs 10 sec on an MSSQL server and 5 min (!!!) on a PSQL. Why?!! Is it just the way the PSQL performs?!! Thank you.

Part and Inventory Search

Back
Top