Mike Copeland wrote on 2011-03-02:

<snip>

> Oh, here's the code from the INIT event on the form (I've tried various

> other events, and even put it in the click event of a button on the

> form, no change) Also, you'll notice there's no indication of how I'm

> getting the data from MySQL. The sample below has the same speed issues

> described above, but as you can see the retrieval from the MySQL server

> is not involved in the timing and is actually very fast in all

> scenarios. ----------------------------------------------------------

>

> MESSAGEBOX('Starting to load Grid. Click OK to

> start...',0+64,'Notice') LOCAL ttimestart,ttimeexp SELECT sku FROM

> skus into temp WHERE active=1 order by sku SELECT temp GO TOP IN temp

>

> ttimestart=seconds()

>

> SCAN WHILE !EOF('temp')

> thisform.ctGrid.addcomboitem(1,temp.sku)

> ENDSCAN

>

> ttimeexp=seconds()-ttimestart

> MESSAGEBOX('Finished.'+CHR(13)+ALLTRIM(STR(RECCOUNT('temp')))+' items

> added.'+;

> CHR(13)+'Time elapsed:

'+ALLTRIM(STR(ttimeexp,6,2))+' seconds',0+64,'Notice')

---------------------------------------------------------------------- -

Mike,

Move the code to a new method on the form. Then call it from the

ctGrid.FirstDraw event.

See if turning off the fancy Windows 7 graphical themes with SYS(2700,0).

Tracy Pearson

PowerChurch Software

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/000001cbd9b1$23333b70$6999b250$@com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.