Hello, How can I make my database available for download? Best regards, Jacque > Date: Tue, 25 Sep 2012 20:00:28 +0200 > From: delphi@xxxxxxxx > To: yunqa@xxxxxxxxxxxxx > Subject: [yunqa.de] Re: Subscription confirmation for 'yunqa' > > On 25.09.2012 18:53, Jacque Lafitte wrote: > > > I am currently testing DISQLite3 and it seems quite fast when running > > joined queries (sub-second speed). However, when I want to display an > > entire table using TDISQLite3UniDirQuery and TClientDatabase, it takes > > several seconds to process. You can se my code below. What I am doing wrong? > > > > tbDISQLite3Target.SelectSQL := 'SELECT * FROM > > CUSTOMERS'; > > // > > cdsClientDataSetTarget.Open; //<-- This data set is > > linked to a data source and from there to a grid. > > > > In fact, when I run the same simple query in SQLiteSpy, it also takes > > several seconds to return. The table size is about 700 records with 37 > > fields and 10 indexes. > > SQLiteSpy is known to display queries about as fast as it gets. To > determine the overhead of data display I suggest to to run your query > and retrieve records without storing. If this also takes a few seconds, > you need to optimize your query to improve performance. > > Other than that, I found TClientDataset to be quite slow when it comes > to display larger amounts of data. If you find this to be the bottleneck > you might want to look for a faster, custom solution. > > For more precise help please make your database available for download. > > Ralf > _______________________________________________ > Delphi Inspiration mailing list > yunqa@xxxxxxxxxxxxx > //www.freelists.org/list/yunqa > > >