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 strongm 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: Francelino
- Order by date
-
Open Table
The support is lost in this case. They stay only testing, and nothing of solution. They think that problem is with string connection. My application use the string same string connection of PGAdmin2. If the View data is slow in PGAdmin2 the Open is slow in my application. Do you want a...- Francelino
- Post #7
- Forum: PostgreSQL Inc.: PostgreSQL
-
Case
You don't understand. The case is in data into a table. Example: Select * from [Table] Where [collum] like 'a%'. This query must return the records: A...* return a...* no return Á...* no return I found in help the operator ~~* that works. Example: Select * from [Table] Where [collum] ~~*...- Francelino
- Post #3
- Forum: PostgreSQL Inc.: PostgreSQL
-
Open Table
Well. I understood your reply. Really i don't need retrieve all data, i can make a page index as you said. But the application is build and it works well with same DB in Access, and work very slow with DB in PostGreSQL. In the next application i will make a system that no requery entire...- Francelino
- Post #5
- Forum: PostgreSQL Inc.: PostgreSQL
-
Open Table
1-)The client is pgadmin2 and is in same machine that the server reside. In network the speed is 100mb. 2-)Yes, is the entire table. 3-)In Windows, but i try in Linux(Server) with pgadmin2 in Windows(Client) over network, and is very slow. 4-)Yes, and the response is very fast, but for scroll i...- Francelino
- Post #3
- Forum: PostgreSQL Inc.: PostgreSQL
-
Case
Hi. How i can execute a query in PostgreSQL with, case insensitive and accent insensitive. Thank's. Ass.: Fabio Alves Francelino- Francelino
- Thread
- Replies: 3
- Forum: PostgreSQL Inc.: PostgreSQL
-
Open Table
Hi. I have a table with 26318 rows and a 20 fields. And a open command is very slow. The same table in Ms Access is 50x more fast. How i can increase this speed time. I am use Delphi 6.0 and ADO. Thank's, sorry about my english. Ass.: Fabio Alves Francelino- Francelino
- Thread
- Replies: 6
- Forum: PostgreSQL Inc.: PostgreSQL
