Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
DBGrid not working with big table
Free Pascal
Website
Downloads
Wiki
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Bugtracker
CCR Bugs
IRC channel
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
MOVED: Convert a delphi f...
by
trev
[
Today
at 03:49:19 am]
MOVED: Copying a textbox ...
by
trev
[
Today
at 03:46:11 am]
MOVED: Illegal type conve...
by
trev
[
Today
at 03:44:50 am]
MOVED: Adding a new event...
by
trev
[
Today
at 03:44:03 am]
Illegal type conversion s...
by
Fred vS
[
Today
at 02:35:38 am]
snake biting its tail
by
friend
[
Today
at 02:10:33 am]
Copying a textbox also co...
by
dseligo
[
Today
at 01:57:46 am]
resize Form when enable o...
by
eldonfsr
[
Today
at 01:43:31 am]
Get Free space of Disk or...
by
eldonfsr
[
Today
at 01:31:25 am]
Obtener ruta de archivos ...
by
Yoandy Calvelo
[May 26, 2022, 10:58:17 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: DBGrid not working with big table (Read 1581 times)
Heinz
New Member
Posts: 10
DBGrid not working with big table
«
on:
October 19, 2021, 06:10:52 pm »
I have a table with 5 rows and DBGrid show instantly the result.
Then I switch query selecting a table of more than 50000 rows and the result are only empty columns (with correct title though).
The same select works on embarcadero sql.
Why?
Logged
wp
Hero Member
Posts: 9605
Re: DBGrid not working with big table
«
Reply #1 on:
October 19, 2021, 06:27:14 pm »
Quote from: Heinz on October 19, 2021, 06:10:52 pm
Why?
No idea what you are doing. The attached project creates a dummy sqlite3 database with 1 million records within about 10 seconds, and when the application is opened a second time it loads the table into a dbgrid instantly.
Logged
Mainly Lazarus trunk / fpc 3.2.0 / all 32-bit on Win-10, but many more...
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
DBGrid not working with big table
TinyPortal
© 2005-2018