¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
andybigbos
µù¥U®É¶¡: 2004-12-01 ¤å³¹: 64 ¨Ó¦Û: ¥x¤¤
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤Q¤@¤ë 28, 2018 3:56 pm ¤å³¹¥DÃD: ³t«×ÅܺC¤F |
|
|
½Ð°Ý¦U¦ì¤j¤j,¦b¬d¸ß¸ê®Æ®w®É,¦³®ÉÅܺC¤F,°h¨ì®à±«¶iµ{¦¡,¦A¬d¸ß¤@¦¸¤SÅܧ֤F,¨Ï¥Î¤@°}¤l«á.¤SÅܺC¤F,¦³¤j¤j¸I¹L³o¬O¤°»òª¬ªp¶Ü?¥i§_¤£§[«ü±Ð |
|
¦^³»ºÝ |
|
|
CPS0204
µù¥U®É¶¡: 2014-08-24 ¤å³¹: 451
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤Q¤@¤ë 28, 2018 4:03 pm ¤å³¹¥DÃD: |
|
|
½Ð°Ý§A¬O VFOXPROªºDBF,©Î¬OSQL SERVER?
³æ¾÷©Î¬O¦³¥t¥~¤@¥xªº SERVER |
|
¦^³»ºÝ |
|
|
andybigbos
µù¥U®É¶¡: 2004-12-01 ¤å³¹: 64 ¨Ó¦Û: ¥x¤¤
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤Q¤@¤ë 28, 2018 4:07 pm ¤å³¹¥DÃD: |
|
|
VFP + DBF + ºô¸ôºÏºÐ¾÷¨Ï¥Î |
|
¦^³»ºÝ |
|
|
CPS0204
µù¥U®É¶¡: 2014-08-24 ¤å³¹: 451
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤Q¤@¤ë 28, 2018 5:29 pm ¤å³¹¥DÃD: §Ú·Q |
|
|
1.§Ú·QÀ³¸Ó¥X¦bºô¸ô¤À¨Éªº±±¨îÅv¤W± (WINDOWS ¼h±
2.©Î¬O¬d¸ßDBF ¬O±N쥻SERVERªºDBF COPY ¦Ü¥»¾÷ªºRAM¤¤¹Bºâ,·íÀɮפj©ó§AªºPCªº°O»õÅé®É,·|¦s¤J§Aªº¥»¾÷µwºÐ!³y¦¨ÅܺC,©Î¬O,¬d¸ß®É¦³¨ä¥Lºô¤Í¦bÂê©wÀɮשÎRECORD¶i¦æLOCK,UNLOCK.........©Ò¥H§Aªº°Ê§@¥²»Ýµ¥¤@¤U
3.©Î¬OWINDOWS cache memory ¾÷¨î¤W
1/2/3³£¦³¥i¯à
«Øij:§ï¥ÎSQL SERVER,100% ¨S°ÝÃD,¥B³t«×§Ö100¿¥H¤W! |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤Q¤@¤ë 30, 2018 6:51 pm ¤å³¹¥DÃD: Re: §Ú·Q |
|
|
CPS0204 ¼g¨ì: | 1.§Ú·QÀ³¸Ó¥X¦bºô¸ô¤À¨Éªº±±¨îÅv¤W± (WINDOWS ¼h±
2.©Î¬O¬d¸ßDBF ¬O±N쥻SERVERªºDBF COPY ¦Ü¥»¾÷ªºRAM¤¤¹Bºâ,·íÀɮפj©ó§AªºPCªº°O»õÅé®É,·|¦s¤J§Aªº¥»¾÷µwºÐ!³y¦¨ÅܺC,©Î¬O,¬d¸ß®É¦³¨ä¥Lºô¤Í¦bÂê©wÀɮשÎRECORD¶i¦æLOCK,UNLOCK.........©Ò¥H§Aªº°Ê§@¥²»Ýµ¥¤@¤U
3.©Î¬OWINDOWS cache memory ¾÷¨î¤W
1/2/3³£¦³¥i¯à
«Øij:§ï¥ÎSQL SERVER,100% ¨S°ÝÃD,¥B³t«×§Ö100¿¥H¤W! |
¤j¤j
SQLServer¦p¦ó¥[§Ö³t«× _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
CPS0204
µù¥U®É¶¡: 2014-08-24 ¤å³¹: 451
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤Q¤G¤ë 01, 2018 8:43 am ¤å³¹¥DÃD: |
|
|
¤j¤j
SQLServer¦p¦ó¥[§Ö³t«×
***********************************
1.dbf ªº SELECT * °µªk¬O±Nºô¸ôªÚ¾FªºDBF COPY ¦Ü§AªºRAM(DISK)µM«á¦b¥Ñ¤º³¡¥h¿z¿ï,Y¦³100MB,COPY´Nn5-10¬í
2. SQL SERVER ªº SELECT * ,¥u¶Ç¦^§A¿z¿ïªº¸ê®Æ,¨Ò: 100¸Uµ§,¥u¦³3µ§²Å¦X,¶Ç¦^3µ§, 0.00001¬í¤£¨ì
©Ò¥H·|¥[§Ö«Ü¦h,¦³®É¤£¥u100¿ |
|
¦^³»ºÝ |
|
|
ezpos
µù¥U®É¶¡: 2011-04-20 ¤å³¹: 323
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤Q¤G¤ë 01, 2018 10:58 pm ¤å³¹¥DÃD: |
|
|
§Ú·Q»¡¤@¸Uµ§¸ê®Æ¦p¦ó¥[§Ö³t«×!!
ì¨Ó¬Oselect ¥[¤Wwhere _________________ ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú
http://www.twelife.com ¥xÆW¥Í¬¡ºô |
|
¦^³»ºÝ |
|
|
CPS0204
µù¥U®É¶¡: 2014-08-24 ¤å³¹: 451
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤Q¤G¤ë 06, 2018 6:09 pm ¤å³¹¥DÃD: |
|
|
§Ú·Q»¡¤@¸Uµ§¸ê®Æ¦p¦ó¥[§Ö³t«×!!
ì¨Ó¬Oselect ¥[¤Wwhere
*************************
¾A·íªºµ¹SQL SERVER TABLE ¥[¤W¯Á¤ÞÁä,·|§ó¥[§Ö¬d¸ß³t«× |
|
¦^³»ºÝ |
|
|
ckp6250
µù¥U®É¶¡: 2004-07-30 ¤å³¹: 1645
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 10, 2018 4:51 pm ¤å³¹¥DÃD: |
|
|
§Ú»{¬°¡A°ÝÃD¤£¬O¥X¦b¡i ºô¸ôºÏºÐ¾÷¡j
§Ú´ú¸Õ¤Fºô¸ôºÏºÐ¾÷¤Wªº¤@Ó dbf , ¦³ 227 ¸Uµ§¡A
§Ú¤U¤F¡@select * from xxx where xxx
¼´¦^¤F14000µ§¡A¤]¥un0.03¬í |
|
¦^³»ºÝ |
|
|
akwang
µù¥U®É¶¡: 2004-11-06 ¤å³¹: 24 ¨Ó¦Û: ccf
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤@¤ë 11, 2019 9:19 am ¤å³¹¥DÃD: |
|
|
这个问题¦Pý©§xÊð§Ú«Ü¤[¤F
DBF©ñ¦bªA务¾¹¨½¡A¤å¥ó夹¦@¨Éªº¤è¦¡
¥u¦³1个«È户ºÝµn录¾Þ§@没问题¡A¦³²Ä¤G个«È户ºÝµn录¦Z开©l变ºC¡C¡C¡C¡C |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4225 ¨Ó¦Û: Taipei,Taiwan
²Ä 11 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤@¤ë 11, 2019 10:57 am ¤å³¹¥DÃD: |
|
|
³oÓ°ÝÃD±q¦³dbf´N¥X²{¤F.
©Ò¥H¤~·|¾É¤J sql server ªºclient-server ¬[ºc
·íµM¥i¥H¥hgoogle¤@¨Ç¤åÄm.
¦pªG¤£¨Ï¥Î sql server,
¨º´Nn¤p¤ß³]p¸ê®Æ¦s¨úªº¤è¦¡,
¦h¥Îindex seek,
¤Ö¥Î·|Åܦ¨ table scanªº locate,filter µ¥µ¥,
¤@¥¹¶i¤J table scan ,
¸ê®Æ³B²z½d³ò´NÅܦ¨¾ãÓtable,
³t«×´NºC¤F.
sql ³B²z¬O¤@Ó¦n¿ìªk,
¥H«e°Q½×¹L,
sql ³B²z³t«×¨ä¹ê¤ñ·Q¹³¤¤§Ö±o¦h.
¤£¹L¤]¥i¯à§óºC,
n¦h¦h½m²ß,
¤~¯à´x´¤sql»P¶Ç²Î©R¥O¬Û³Bªº§Þ¥© _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
|