Re: Mixed pixbuf and text

[Dan <dan entropy homelinux org>]

Jan Hudec wrote:

> > When you issue a query to a database server, it doesn't return the
> > results in bits and pieces; it completes the query, and then gives you
> > everything at once.
> >    
>
> This is, fortunately, false about many database servers. When you
> execute a query, it gives you cursor. You ask the cursor for lines by
> one. It depends on the nature of that query, how much work has to be
> done before the first result depends on the nature of the query.
>
> Well, if your database actually sends you the first results reasonably
> fast, you can feed say 10 of them to the tree-view, thaw it (you foze
> it, right) and let the mainloop run so it can process the events.
>  
Are you sure on this?
My understanding was that the DB server executed the query completely, 
and *then* gave you a cursor. At least that's how MySQL appears to do 
things. If I have a query that takes a while to execute, I get 
absolutely nothing for seconds, and then get all the results at once. 
For example if I set up a 'pass-through' query in MS Access ( a 
pass-through query is where Access doesn't process the SQL at all - it 
just hands it to the DB server and waits for the results ), the results 
always come back all at once.
Of course I've been wrong before, and will possibly even be wrong again :)

Dan


-- 
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------If you are not the CanIt administrator and you think 
this
message is spam, please give the id 576 and magic value
3af566e289e3 to dan entropy homelinux org to be marked as spam.

NOTE: This message was trained as non-spam.  If this is wrong,
please correct the training as soon as possible.

Teach CanIt if this mail (ID 576) is spam:
Spam:        http://entropy.homelinux.org/canit/b.php?c=s&i=576&m=3af566e289e3
Not spam:    http://entropy.homelinux.org/canit/b.php?c=n&i=576&m=3af566e289e3
Forget vote: http://entropy.homelinux.org/canit/b.php?c=f&i=576&m=3af566e289e3
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS